A Microsoft SQL Server community of 1,889,676 DBAs, developers and SQL Server users

Learn how you can load Extended Events with PowerShell, nice and fast.  Read more...

Greg Larsen shows you how to use the Transaction ID value to identify the object_id for a deleted table.  Read more...

In this article, we will learn how to work with PolyBase using Azure SQL DWH.   Read more...

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.  Read more...

Join Microsoft Data Platform MVP, Grant Fritchey, for our next Database DevOps demo webinar. He’ll be plugging Redgate’s tools into Git and Jenkins to show you how Redgate's Database DevOps solution helps you build, test and deploy your database changes alongside your app code.  Read more...

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...

Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the team to mistakes or omissions, such as missing indexes, that are likely to cause performance problems in production. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities. William Brewer describes the two technical approaches to database code analysis, static and dynamic, and suggests some tools that can help you get started.  Read more...

Learn how you can use tSQLt to test your COALESCE queries.  Read more...

The transaction log backup is stored in SQL Server proprietary format, just like the transaction log itself. Even though the transaction log backup is in a special format, Microsoft has provided us with the fn_dump_dblog() function to read transaction log backups. This function is undocumented, so you should use care when using this function in a production environment.  Read more...

The first article in this Stairway Series makes the case for test-driven development.  Read more...

In this module you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single...  Read more...

One of the new options available in SQL Server 2017 is the ability to specify a filegroup when using SELECT..INTO...  Read more...