What is the hardest part of planning a SQL Saturday?
For me so far it has been the speaker selection. Getting sponsors didn’t prove to be difficult, we have a...
2011-07-27
516 reads
Tim Radney - Database Professional
Get count of folders using Power Shell
More on my recent PowerShell project. I recon I have taken on the challenge to handle this entire request using...
2011-07-25
553 reads
Starting and Stopping a Remote Service with PowerShell
A recent project I was working on required me to move folders from a staging location to a processing location....
2011-07-18
1,975 reads
My first PowerShell Script to Move Folders
I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I...
2011-07-15
1,977 reads
SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89...
2011-07-14
607 reads
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked...
2011-07-04
731 reads
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
418 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
862 reads
SQL Saturday #89 Atlanta GA
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered...
2011-06-15
497 reads
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A...
2011-05-31
1,366 reads
Blogs
KDA: Echoes of Deception - Onboarding
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
Kusto Detective Agency - Intro
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
The Book of Redgate: Customer Quotes
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Forums
Life Moves Pretty Fast
Comments posted to this topic are about the item Life Moves Pretty Fast
Parse XML data from SQL table using temp tables and variables
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers