SQL Server Connections
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,405 reads
Blog Posts
SQL Server 2005 Administrator's Pocket Consultant available
Saw this at the book store this evening and picked it up.
SQL Server 2005 Administrator's Pocket Consultant
I'll spend the...
2005-12-18
1,494 reads
Salary Survey
SQL Server Magazine has just published its annual salary survey. I don’t really recall how they did it in past...
2005-12-17
1,540 reads
Crypt Packages for Perl
This is one of those "bang head here" issues. I was trying to install
Net::SSH::Perl, which basically drives SSH through Perl,...
2005-12-16
1,794 reads
Early Christmas
At least for me 🙂
My wife and I put an offer in on a house this past Monday and spent...
2005-12-16
1,379 reads
Missing some folks
In a community the size of SQL Server Central, it's natural for people
to come and go, especially with contributions to...
2005-12-15
1,324 reads
Anyone want to handle this?
I get a lot of email at SQLServerCentral.com on a variety of topics. Complaints about my writing, comments on the...
2005-12-14
1,449 reads
Simple script to show what drives all databases are on
Had a need for this the other day. We just needed a quick dump of which
drives each database was using....
2005-12-09
1,370 reads
Denver Launch
I wrote a little in the editorial, but I wanted to drop some other observations here.
First, apologies for not blogging...
2005-12-07
1,437 reads
New SQL Server 2005 Books Online available
I saw this first on Karen Watterson's blog. Microsoft has released an update to SQL Server 2005's Books Online:
Download
A quick...
2005-12-07
1,461 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