Reading execution plan sql server use of Plan Explorer
AdvertisementsPlan Explorer
I recently started using this. Since it was licensed earlier, now it’s free. This is an awesome tool for...
2018-11-01
2,612 reads
Blog Posts
Three ways a virtual Database Administrator (vDBA) could be just what your business needs
How often have you felt like you need an extra pair of hands? When you’re planning a party? Maybe. When...
2018-11-01 (first published: 2018-10-24)
2,489 reads
How do I look at my error log if SQL won’t open?
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you...
2018-10-31 (first published: 2018-10-22)
2,624 reads
How to create DACPAC file?
In this post I will explain what the DACPAC is and how to create it. In previous post in DevOps...
2018-10-31
2,581 reads
Installing Azure Data Studio
Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the...
2018-10-31 (first published: 2018-10-19)
4,486 reads
PASS Summit, SQLTrain and My First US SQL Saturday
Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...
2018-10-31
258 reads
Speaking at PASS Summit
The title says it all, this year I have been selected as a speaker at the world’s largest Microsoft Data...
2018-10-31
259 reads
String or binary data would be truncated: get the full picture in SQL Server 2017
SQL Server 2019 Preview (CTP 2.0) introduced a long-awaited improvement to an error message that’s been around in SQL Server...
2018-10-31
508 reads
Email Alerts with SIOS DataKeeper
Over the past few weeks I wrote a 3-part series on how to configure email alerts based on Perfmon Counters,...
2018-10-30
80 reads
Invalid value given for parameter PASSWORD. Specify a valid parameter value.
I still use sp_help_revlogin to transfer logins between servers. I know there are other options, including a set of Powershell...
2018-10-30 (first published: 2018-10-17)
7,706 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
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...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
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