Where are my 32-bit Perfmon Counters?
I have run into this before, but not in this same way, so I decided it would be worth writing...
2014-05-05 (first published: 2014-04-23)
3,408 reads
Nebraska SQL from @DBA_ANDY
Why does my Failover Cluster Instance Keep Failing Back and Forth?
A few months ago I was paged by a client because their SQL Server Failover Cluster Instance (FCI) was experiencing...
2014-04-25 (first published: 2014-04-17)
8,117 reads
I Know I Shouldn't Shrink My Log file, BUT...
As a managed services DBA, I frequently have to clean up after other people's mistakes. (Come to think of it,...
2014-04-03
1,971 reads
We Are Hiring!
My employer Ntirety (a division of HOSTING) is currently looking for multiple SQL Server DBA's. As you have probably seen...
2014-03-31
1,225 reads
Backup Checksums and Trace Flag 3023
One of the items I always flag when performing a health check on a server is whether backups are being...
2014-03-28 (first published: 2014-03-25)
3,602 reads
Error 701 - Insufficient System Memory - Now what?
This story begins, as so many often do, with a few key elements:1) A client who experienced a problem on...
2014-03-26 (first published: 2014-03-20)
9,532 reads
A New Day at #Ntirety
We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network...
2014-03-18
584 reads
Why Did My Job Fail Anyway?
One of my biggest pet peeves when I check a new SQL Server for a client is the fact that...
2014-03-12
1,057 reads
Working From Home
I have been working 100% from home for almost four months now, and one of my former coworkers recently hit...
2014-02-22
531 reads
T-SQL Tuesday #051: Always Hedge Your Bets
It's time for T-SQL Tuesday again and this month's host is my former co-worker, the @SQLRNNR himself, Jason Brimhall. Jason's...
2014-02-11
718 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