SQL Server in Space - HASSP
A successful launch, and recovery, of SQL Server running below a balloon.
Time Traveling with Temporal Tables on SQL Server 2016
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates.
Protecting production data in non-production environments
In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production...
Statistics in SQL: The Mann–Whitney U test
Phil Factor shows how to use the Mann-Whitney U test in SQL to to find out whether two samples come from the same distribution.
Improving Log Shipping
Today Steve Jones looks at possible ways to improve log shipping and asks for your input as well.
PowerShell Tool Time: Our First Toolbox
Learn how to begin assembling your functions and code into modules you can easily call from any session.
What is the biggest mistake you made in production?
When you have sysadmin access, you are bound to make a big mistake in production at some point in your career - in this post Tara Kizer looks back at what hers were.
Appreciating New Perspectives
Today Steve Jones talks about understanding and having empathy for other points of view.
Resolving could not open a connection to SQL Server errors
Have you ever gotten connectivity errors from SQL Server? Jugal Shah explains the common causes for these errors, and advises on the steps you can take to resolve them.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Why Your Index Isn't Being Used? - Reading Execution Plans to Find the Real Culprit
Comments posted to this topic are about the item Why Your Index Isn't Being...
Question of the Day
Distance Metric Algorithms
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers