(Lukas Eder) SQL Server is known to have a very strict interpretation of the SQL standard. For instance, the following expressions or statements are not possible in SQL Server:

(Tyler Chessman) When it comes to relational databases, most organizations run heterogeneous environments. SQL Server DBAs, IT professionals, and business intelligence (BI) practitioners will likely need to connect to an Oracle database at some point in their career.

(Kalen Delaney) My Hekaton (aka In-memory OLTP) books is with the publisher. And I have no doubt they will do a much better job than my previous publisher did in bringing my SQL Server 2012 Internals Book into the light of day.

(K. Brian Kelley) I know SQL Server 2012 added a feature where you can use contained databases. I also have heard that these databases can have users which can be authenticated by the SQL Server. However, the users don’t appear in the standard sys.sql_logins or sys.server_principals catalog views. H

(isilefe) Nowadays, I am reviewing the tools for troubleshooting SQL Servers since I will deliver a training in Dublin next week. While reviewing them, i would like to summarize them with a blog series. Now, first one is SQLDiag. SQLDiag is a general purpose diagnostics utility that can collect the

(Jason Brimhall) Frequently we hear the analogy that is like opinions, everybody has one and not all of them are good (some may stink).

(Kenneth Fisher) When granting or denying permissions to the tables within a database you have two options. You can either add the user/role to one of the preexisting database roles

(Pinal Dave) This is the second part of the series Incremental Statistics. Here is the index of the complete series.

(Andy Novick) There is a stored procedure that must be run by only one user at a time. How do to I prevent multiple users from running the stored procedure at the same time?

(Pinal Dave) This is the first part of the series Incremental Statistics. Here is the index of the complete series.