How Much Should You Post Online About Your Life?
I’ve touched on it some in the past, but it’s a question that comes up a lot when we discuss...
2009-08-21
2,360 reads
Articles
Protection Close To Home
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
581 reads
Protection Close To Home
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
839 reads
Protection Close To Home
For the Friday Poll this week, Steve Jones is wondering what type of data protection you use at home for your information. Especially those all important family photos.
2009-08-21
1,137 reads
There is no excuse
I read Jack Corbett's blog entry,No Training Budget Still No Excuse, last week and thought it was excellent. In fact,...
2009-08-21
1,956 reads
I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
2009-08-20
4,229 reads
Database Mirroring Using T-SQL
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
2009-08-20
3,401 reads
Flat File Imports with SQL Server Integration Services 2008
A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.
2009-08-20
4,444 reads
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
438 reads
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
2009-08-20
438 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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