Format Disk for SQL Server
Managing large SQL Server inventories requires standardisation. Do your research , create the scripts , and apply.
Occasionally, custom changes are required . This...
2011-09-28
4,098 reads
Blog Posts
Online index rebuilds
G’day,
I’m probably not the only one that has noticed that as the volume of data gets bigger in out databases,...
2011-09-28
1,040 reads
Posting This Week
I just wanted to do a quick post to let everyone know that I am in fact going to be...
2011-09-28
490 reads
RTO in Disaster Recovery
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,275 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!
It’s time for another SQL Saturday at the beautiful University...
2011-09-28
715 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…! It’s time for another SQL Saturday at the beautiful University of Iowa campus. The speaker lineup looks great....
2011-09-28
10 reads
SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,619 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
538 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,315 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,441 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
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