Book: Expert Performance Indexing for SQL Server 2012
After about a year of work and a month of waiting, the book I wrote with Ted Krueger (Blog | @Onpnt)...
2012-07-10
1,875 reads
Blog Posts
Retrieving password policy settings for SQL login accounts
Today, I wrote the following query for our internal audit report for SAS70. This query provides all the necessary details...
2012-07-10
3,421 reads
Service Broker Adventures: Stucked Queue Monitors
This week I'm in London helping a client with its large scale Service Broker deployment,
mainly troubleshooting some strange problems with...
2012-07-10 (first published: 2012-07-03)
4,262 reads
SQLSaturday #122, Louisville
Date: July 21, 2012
Session: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-07-10
661 reads
SQLSaturday #164, Cleveland
Date: August 18, 2012
Session 1
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe...
2012-07-10
697 reads
SSIS 2012 Change Data Capture (CDC) Control Task
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
4,113 reads
Time Zones
Why don’t we have a function like the one in this article to convert from time zone to time zone?...
2012-07-10
960 reads
Back Across the Pond
This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...
2012-07-09
995 reads
Blueprint for consulting riches
As a business intelligence architect consultant, I have met many people out there who are as good or better than...
2012-07-09
1,527 reads
Dynamic Multi-Threaded SSIS using C#
Here is a snippet of code that will assist in the dynamic ‘spin-up’ of duplicate SSIS packages. To put it...
2012-07-09
1,461 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