MDX Puzzle #4
This puzzle is rather simple, but it does introduce a few new things. Using T-SQL you typically filter queries with...
2010-07-28
556 reads
SQL University – Disk Capacity Planning
This week at SQL University we are talking about capacity planning. I am the guest lecturer for this topic, and...
2010-07-28
5,043 reads
Interviewed by Andy Leonard
Andy Leonard is posting interviews of all the candidates PASS Board of Directors on his blog and mine is up...
2010-07-28
389 reads
Interviewing for the PASS Board of Directors
My nomination application made it through the committee. I got an email yesterday telling me that I needed to schedule...
2010-07-28
802 reads
PASS Update #38 (SQLSaturday Wiki)
For the past couple years we’ve had a few different documents that covered how to run a SQLSaturday, but as...
2010-07-28
645 reads
Presenting at SQLSaturday #40 – South Florida
I'M ON A BOAT!
This is just a quick note to say that I’ll be in South Florida this weekend presenting...
2010-07-27
421 reads
Hit and miss
Or “Monitoring plan cache usage”
For people interested in the details of how SQL is using and reusing execution plans, there...
2010-07-27
1,145 reads
Count(*) or Count(1) ?
Every so often on the on-line forums, the question of : Which is better Count(*) or Count(1) ? will occur. So can...
2010-07-27
1,476 reads
Powershell Remoting with SQL Server
One of the best things to come out with Powershell V2 is remoting and asynchronous calls. Between the two of...
2010-07-27
1,581 reads
Slack Traveler
I realized over the weekend that I hadn’t booked a hotel for my SQL Saturday #28 trip to Baton Rouge....
2010-07-27
679 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers