Drop and Recreate
Steve Jones notes that disasters come in all shapes and sizes, but a little prep that you might not have thought of can reduce the scale of the issues.
Debugging Natively-Compiled Stored Procedures Statements
Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.
The Last Job
Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.
What, when and who? Auditing 101 - Part 2
In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.
Finding SQL Server views with (or without) a certain property
In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.
Citizen Programmers
Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.
Cloud Identities versus Federated Identities in Office 365
Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?
SQL Monitor Custom Metric: Excessive Virtual Log Files in Transaction Log
This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.
SQL Server Survey
How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.
Lead and Lag Functions in SQL Server 2012
Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers