Quickly Find Your DDL Triggers with PowerShell
As a consultant I spend much of the first day or two at a client site discovering everything I can...
2011-05-20
1,320 reads
Blog Posts
Re-blog – May 13-19
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Oddly enough,...
2011-05-20
441 reads
Replicating XML Columns
One caveat that’s worth mentioning is replicating the XML data type in
SQL Server using Merge Replication. Sometimes, when replicating...
2011-05-20
1,415 reads
SQL Lunch Returns: MVP Max Trinidad (Let’s Talk about SQL Powershell)
I know you have missed the crazy antics, but after taking a short hiatus from my community contributions, the SQL...
2011-05-20
1,128 reads
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up...
2011-05-20
1,027 reads
Answering SQL Questions and Forum Fun Overview
Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...
2011-05-19
651 reads
Change SQL Servers Authentication Mode with PowerShell
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,826 reads
IT and Innovation
This is a powerful quote:
“This is the digital world IT must keep up with–one where Apple can view a...
2011-05-19
744 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it last year with the exception that I at least...
2011-05-19
3 reads
MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it...
2011-05-19
516 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers