Isn't there an easy way to get a 2-digit day from a SQL query?<BR><BR>SELECT datepart(dd, getDate()); <BR><BR>will return "1" for July 1st. How can I get it to return ...

With JSON now the default format for moving data between clients and servers, SQL Server adds JSON support to make it easier to get your data out of the database and down to the client. SQL Server ...

I've been playing around with the new Microsoft service, currently in preview and it's time to show off what it can do. Have you ever struggled with a database performance problem or ever struggled to ...