ODBC DSN on 32/64 Bit Systems
Funny how you can work with data a long time and still run into something new. I’ve been working on...
2011-07-06
748 reads
SQLAndy
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
918 reads
Book Review: Hour of the Horde
Hour of the Horde by Gordon R. Dickson ($1-5 @ Amazon) is an interesting story. The basic plot is that one...
2011-07-01
424 reads
Protected: Google Correlate
This post is password protected. To view it please enter your password below:
Password:
2011-06-30
1,479 reads
Google Correlate
My friend Rob Hatton pointed me to Google Correlate, a new service that lets you explore data trends in a...
2011-06-30
1,791 reads
Energy Efficient Offices
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation...
2011-06-29
884 reads
Attention Speakers–Sign Up for SQLSaturday #85 in Orlando!
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
614 reads
PASS Update #58 (Elections)
Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper...
2011-06-27
671 reads
Growing Leaders
Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great...
2011-06-24
893 reads
Indexes Aren’t Always the Answer
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
981 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