SQL Rally: Don’t Vote for My Sessions
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
473 reads
SQL Server – Powershell Active Directory search
Working with Powershell and Active Directory simplifies some complex tasks for the DBA.
Active Directory is LDAP compliant. This means the...
2012-02-20
1,285 reads
Cartesian/Cross Join
I was once asked in a job interview if I knew what a Cartesian/Cross Join was.
A more interesting question is:...
2012-02-19
2,745 reads
SQL Server Isolation Levels By Example
Isolation levels in SQL Server control the way locking works between transactions.
SQL Server 2008 supports the following isolation levels
Read Uncommitted...
2012-02-18
516 reads
SQLMidlands & SQLLunch
Many thanks to all those that turned out to see my presentation on Thursday (16th of Feb) of “Cursors are...
2012-02-18
762 reads
How can I configure SQL Server to listen on multiple TCP/IP ports?
Run the SQL Server Configuration Manager, expand SQL Server Network Configuration and select the protocols for appropriate instance. Double click...
2012-02-18
10,341 reads
Re-blog – February 10 – February 16
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-17
617 reads
SQL Server 2012 (“Denali”): Microsoft StreamInsight
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event...
2012-02-17
3,152 reads
Performance VC Feb Meeting
Jes Borland will be speaking for the Performance Virtual Chapter this month. Don’t miss out on this free training. Here...
2012-02-17
758 reads
Split Typeperf Output in More Managable Chunks
I really like using typeperf for perfmon counter collection. It allows me to save a collection of counters to monitor and store those readings in a csv file for...
2012-02-17
56 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers