SQL Saturday #143 - Washington, DC
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
541 reads
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
541 reads
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
1,000 reads
I think most DBAs know that you can use the Windows Performance Monitor to capture performance metrics for your SQL...
2012-12-04
873 reads
Continuing on my recent trend of using undocumented stored procedures, this week I thought we can cover using xp_delete_file to...
2012-11-21
3,494 reads
UPDATED -- Dec 31, 2012 -- Be sure to read Part 2 of this post discussing xp_dirtree.
Last week I blogged about how...
2012-11-13
56,711 reads
If you're a DBA like me then you're probably pretty detail-oriented and like to keep things very organized. For example,...
2012-11-06
719 reads
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
1,976 reads
Starting with SQL Server 2005, Microsoft introduced Dynamic Management Views to help DBAs see what's going inside of SQL Server....
2012-10-23
2,510 reads
You have 5 instances running. How do you know which one is killing your CPU?
As you can see from Windows...
2012-10-16
542 reads
Right out of the box, SQL Server makes it pretty easy to grant SELECT, INSERT, UPDATE, and DELETE to all...
2012-10-10
10,448 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
Comments posted to this topic are about the item Finding Marks
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers