(Erin Stellato) SQL Server introduced In-Memory OLTP objects in SQL Server 2014. There were many limitations in the initial release; some have been addressed in SQL Server 2016, and it’s expected that more will be addressed in the next release as the feature continues to evolve.

(Sean Gallardy) One of the new features of SQL Server 2016 is the ability to use SQL Server with Failover Cluster in a workgroup rather than joined to Active Directory. When working with SQL Server and Failover Clustering in a workgroup, many of the abilities that are normally used with Active Direc

(Kenneth Fisher) If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance on?”. You probably are aware that the default instance uses port 1433.

(Pinal Dave) Sometimes back I posted about interesting function AGENT_DATETIME functions which will convert integers into datetime values. Someone commented that there might be some permission issues using this function which is only available in msdb database.

(Brien Posey) As SQL Server changes, so does Integration Services. See the latest SSIS updates, such as added Linux support and an Upgrade Wizard for SQL Server 2016.

(Thomas LaRock) It was just over three years ago that Microsoft introduced the concept of Database Transaction Units (DTUs).

(Jeffrey Yao) Copying data from a table in one instance to a table in another instance is a common task. You could do this with T-SQL and a Linked Server, but what if you can’t use a Linked Server. To make it more difficult, say I have three servers: A, B, C and I want to copy data from a […]

(Pinal Dave) There are some weird situations which I see in SQL Server. This is also a one of the surprising situation. One of my clients reported via below screen shot. Let us see the issue of Master Database in Single User Mode.

(Eli Leiba) Running DBCC CHECKDBs is something that all DBAs should do, but checking the output for errors can be tedious unless you build a process to identify when deeper investigation needs to be done.

(Pinal Dave) While I work on performance tuning most of the time, I do provide consultancy on issues which can be resolved quickly. These are the engagement where I get a lot of content for my blogs as well. Let us learn about the error related to redo log record.