Query Store custom SSMS performance dashboard
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,119 reads
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,119 reads
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is...
2016-09-28
1,733 reads
In the previous article in this blog series I told you my plans of expending my horizons towards the Data...
2016-06-06
1,531 reads
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,840 reads
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine...
2016-04-22 (first published: 2016-04-13)
3,045 reads
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS,...
2016-04-06
696 reads
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
765 reads
You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of...
2016-03-18
702 reads
As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they...
2016-03-14
2,468 reads
Remember that blog post from April this year that I announced working on my first ever SQL Server related book...
2015-09-02
1,552 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers