SSMS Output Window
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time....
2018-03-16
652 reads
Blog Posts
Automation and cleaner code/data are the key to future success
This blog post is a copy of a post I wrote for SQL Masters Consulting as part of T-SQL Tuesday....
2018-03-15
256 reads
Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data...
2018-03-15
283 reads
Profiler for Extended Events: Quick Settings
Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that...
2018-03-15 (first published: 2018-03-05)
1,854 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Database-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-03-15 (first published: 2018-03-05)
2,391 reads
The 700 Milestone
I’ve watched various SQL Saturday milestones go by. I missed 100 in Brazil, but did manage to get to 200...
2018-03-15
275 reads
What's New In SQL Server 2017? at the March '18 Baton Rouge SQL Server User Group
Thanks to everyone to attended the BRSSUG meeting tonight at our sponsor's location at the Baton Rouge Alliance Safety Council location and their awesome classroom training facility.See you next...
2018-03-15
6 reads
Why contractors need recruitment agents?
Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...
2018-03-15
284 reads
Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-14
758 reads
Every Single Execution Plan is an Estimated Plan
All the execution plans are estimated plans. All of them. There fundamentally isn’t any such thing as an “Actual” plan.
Where...
2018-03-14 (first published: 2018-03-05)
1,817 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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