Presentation Deck For Hardware 201 at Denver SQL Server User’s Group on May 19, 2011
I got the chance to give an updated version of Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance...
2011-05-20
787 reads
Blog Posts
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,313 reads
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
433 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,409 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,026 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
649 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,791 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
742 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
515 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers