Using a Dedicated Administrator Connection (DAC) on SQL Server
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,510 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,953 reads
Lenovo’s Cancellation Policy is not consumer-friendly
I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed...
2012-08-09
3,397 reads
Nacho Mama’s Training Class
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,028 reads
How many SQL Servers you run within your environment ? – MAP could be your best bet to answer this question !
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write...
2012-08-08
930 reads
More Suggestions for SQLSaturday Admin Tools
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
468 reads
Cost Savings and Backup Compression
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,853 reads
SQLSaturday #160, Kalamazoo
Date: September 22, 2012
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-08-08
601 reads
How to Data Compress Varchar(MAX)
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
8,050 reads
SSIS: Transfer SQL Server Object using SMO
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,589 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers