Weaning yourself off of SQL Profiler (Part 2)
In a prior post, I shared a script that will take a running trace and show you the XE events...
2017-05-17
567 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
Weaning yourself off of SQL Profiler (Part 1)
In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting...
2017-04-25 (first published: 2017-04-19)
3,312 reads
Automating DBCC DBTABLE – obtaining the disk Sector Size
I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of...
2017-04-04 (first published: 2017-03-22)
10,231 reads
Working with SQLSaturday SpeedPASSes
SQLSaturday SpeedPASSes
I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every...
2017-03-09
456 reads
Identifying a row’s physical location
While you may not need to worry about the physical location of a row very often, every so often the...
2017-03-08
509 reads
Automating DBCC PAGE – Part 3 (Is a Clustered Index physically sorted on disk?)
In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...
2017-02-22
421 reads
T-SQL Tuesday #87 – Beware the Shiny New Toys
Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...
2017-02-14
445 reads
Automating DBCC PAGE, part 2 – determining object names on pages
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
412 reads
T-SQL Tuesday #86: Enhancement Requests
On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known...
2017-01-10
403 reads
Windows Virtual Accounts and SQL Server
How SQL Server uses Windows Virtual Accounts and local groups
Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows...
2016-12-28
2,440 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Langkah mudah Refund tiket Garuda Indonesia?
Cara Refund tiket Garuda/Indonesia dapat dilakukan dengan menghubungi contact center 0821=8154=42.4 /WhatsApp +62813-8537-215.3 atau...
Begini cara menghubungi Call center Garuda Indonesia?
Telepon costumer service Garuda Indonesia di 0821-815442-4 atau (+62) 813-85372 153 kantor pemasaran Garuda Indonesia...
Simak Tips Cara Refund tike pesawat Garuda-Indonesia?
Berikut cara melakukan Refund tiket GARUDA-INDONESIA Telp (0821v8154v424) Call Center resmi Garuda Indonesia (24Jam)...
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers