Steps to Recover Deleted Records from SQL Server Database Tables
In case you forgot to take backup of current database in SQL Server and deleted few records from SQL Server table. The post will help you in recovering deleted...
2019-01-23
12 reads
Blog Posts
The Heart of DevOps Webinar
One of the things that I think about DevOps is that it’s really hard to focus on the hard things...
2019-01-23
257 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit...
2019-01-23
203 reads
What’s the one thing you must do to win the trust of customers?
We’re all spending much more time in the digital world. Ecommerce continues to grow in popularity and we all benefit from the convenience of booking holidays and paying bills...
2019-01-23
16 reads
Availability Groups: When Your Synchronous Secondary isn’t Synchronous
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,045 reads
Critiquing Grant Fritchey: Circa 2008
For several years, I ran a regular feature on this blog, Speaker of the Month. I attend a lot of...
2019-01-22
163 reads
Leveling Up Your TSQL
I thought I’d use this post to round up some of my other posts into a list of often overlooked/unknown...
2019-01-22
255 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
7 reads
Optimizing for Ad Hoc Workloads
Watch this week's video on YouTube
The execution plan cache is a great feature: after SQL Server goes through the effort of generating a query plan, SQL Servers saves that...
2019-01-22
8 reads
SQL Power Doc to Discover, Diagnose and Document SQL Server
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose,...
2019-01-22
336 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers