T-SQL Tuesday #61 – Giving Back
The Season of Giving
The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States,...
2014-12-08 (first published: 2014-12-02)
6,439 reads
A Discussion of SQL Server-Related Topics
The Murder Train is making a stop in Salt Lake City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-10-16
573 reads
The Murder Train chugs into Denver!
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-13
673 reads
T-SQL Tuesday #57: SQL Family and Community
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that...
2014-08-13
620 reads
The Murder train chugs into Raleigh
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-11
689 reads
T-SQL Tuesday #56: Assumptions
Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev...
2014-07-08
797 reads
Avoiding a split brain in database mirroring
You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means...
2014-05-28 (first published: 2014-05-22)
6,156 reads
Cannot start SSAS after install in tabular mode
After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error...
2014-05-19 (first published: 2014-05-13)
4,153 reads
SQL Saturday RVA recap
Wow, what a month. On March 22, 2014, the SQL Saturday train came into Richmond VA (RVA). I was one...
2014-03-28
899 reads
Presenting at the kickoff Lynchburg Va SQL User Group meeting
There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014...
2014-02-17
726 reads
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Dealing with huge heap tables
Recently, our dev teams approach me for advice on improving their huge heap table...
Merge Replication failing with Error converting data type nvarchar to numeric
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers