Customize Software or Process
The build v buy decision isn't the final one. We also need to decide if we'll use software as is or customize it.
Disk Encryption and The Impact to DBAs
As security threats proliferate, the need for encryption will continue to rise. We who are the Guardians of the Data must be ready to make SQL Server respond and to manage the performance issues that are inherent in every data encryption solution.
Data-driven Prototypes
Phil Factor on a tale of how dodgy mock data derailed an otherwise-convincing prototype.
Install Visual Studio 2015 in Server without Internet Connection
Install Visual Studio 2015 in Windows Server without Internet Connection
Binary Files Import and Export
Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.
Disable or Drop
When you need to debug or troubleshoot, Steve Jones wants you to disable, not drop, objects.
Azure DWH part 23: Data Mining
SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW.
Is This Data Science?
An analysis of salaries uses statistics to determine significance of the data. Is this data science?
Free eBook: SQL Server Internals: In-Memory OLTP
In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers