The SQL Server Security Model, Part 1: Logins [Foundations Friday]
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
766 reads
How secure are your databases?
No, not your network. Just your databases. If your company is like most, the strongest security...
2016-01-22
766 reads
Earlier this month, my friend Tim Ford (b|t) proposed an idea:
A 2016 challenge to technical bloggers: 1 introductory level blog...
2016-01-21
443 reads
Happy New Year, and welcome back! One of the projects I undertook over the holidays was to give the site...
2016-01-12
282 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-23 (first published: 2015-11-17)
2,133 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
411 reads
This month, Mickey Stuewe (b|t) hosted T-SQL Tuesday, giving us a topic of “data modeling gone wrong“. This is a fantastic...
2015-11-17
396 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
325 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
216 reads
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
222 reads
Thanks to everyone who participated in week 1 of the SQL New Blogger Challenge! Eight posts were written this week...
2015-11-07
423 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