Upcoming SQL Lunch Webcasts
First, I would like to thank all that have attended and supported the SQL Lunch during our first year. We...
2010-05-13
687 reads
Blog Posts
Upgrading to SQL 2008 R2
Had this on my list todo list, upgrade my laptop that just had plain old SQL 2008 on it. The...
2010-05-13
614 reads
24 Hours of PASS - A Week Away
There’s still time to register for the 24 Hours of PASS, a series of 24 one-hour sessions being presented on...
2010-05-12
740 reads
Are Transaction Rolled Back When CHECKDB Runs?
Ever come across a scary error in the SQL Server log when running CHECKDB against your databases. The error looks...
2010-05-12
514 reads
Attending TechEd 2010
It’s been a couple years since I’ve attended and always found Teched to be a great event, more content than...
2010-05-12
1,225 reads
Audio Webcast – Whats News
Yesterday I though of doing an audio webcast what all I blog. So started audio webcast, its a series of...
2010-05-12
702 reads
Daily SQL Server 2008 New Feature – Day 5
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-12
784 reads
Database Mail set up in SQL Server 2008
by Abi Chapagai – Saturday, May 08, 2010
I have recently set up database mail in SQL Server 2008 in production SQL...
2010-05-12
37,810 reads
IndyTechFest 2010 Offers Free Training
For the third year in a row, IndyTechFest will offer free training for SQL Server DBAs and Developers, .NET Developers,...
2010-05-12
581 reads
Running Totals Using Reporting Services
Sometimes one may need to see a running number that represents a quantity for a period of time. For example,...
2010-05-12
1,458 reads
Blogs
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...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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