Our look at the SQL Server development team continues with Craig Freedman, query tuning expert working on partitioning features. Read a little about a talented software engineer that has been developing database software for over a decade.
Come to the PASS Summit this year and see three of the big influences on SQL Server: Steve Ballmer, Paul Flessner, and Dave Campbell. They're all giving keynotes. And did I mention SQLServerCentral.com is giving away an XBOX 360? Read more about it.
The File Watcher Task does what it says really, it watches a folder waiting for files. When an available file is found the task completes, returning the name of the file for later use.
Most DBAs manage multiple SQL servers, each handling different needs for your business. Even with the diverse uses for different servers, there is often the need to deploy the same scripts to all servers for various purposes. Author Joe Doherty brings us his scripts and technique for executing a script across multiple servers.
In this presentation, Brian shows you how you can use database snapshots for data protection. He shows you how to create a snapshot, read from it and lastly how to do a database recovery from the snapshot.
This article discusses how to upload multiple image or text files to the SQL Server database varbinary column.
In SSIS demostration, you can wrap a package or container in a MS DTC transaction. This type of transaction ensures that if a problem occurs in a package, your data can roll back to a prior state.
In the first part of his series on SQL Server Availability, new author Kumar Parthasarathi brings us a look at Database Snapshots in SQL Server 2005.
In this video, you'll learn how to use the For Each ADO enumerator in SSIS to loop through a table and reconfigure the package based on the rows in the table. You can use this type of example to store meta data about your client and reconfigure the package for each client dynamically.
Solving business problems is an interesting problem for most application developers. Usually the issues are handled in application code, but there are some places where SQL Server can be used to help. Yaroslav Pentsarskyy brings us a creative use of SQL Server functionality to prevent identity theft.
By HeyMo0sh
As someone who’s worked with data for over 20 years and with many cloud...
By HeyMo0sh
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll...
By Vinay Thakur
it has been a year since i have not written much on the blog...
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