The week that was: Friday 15th July 2010
This is just a short post for a Friday, I have no technical content ready to publish today but lots...
2010-07-16
643 reads
Gethyn Ellis
TSQL2sday #008 – Gettin’ Schooled
This months TSQL2sday is being hosted by Robert Davies of MCM and Microsoft fame, you can find his post here....
2010-07-13
799 reads
SSIS - Enabling Logging
Have you ever had a scheduled run of one of your SSIS packages fail? Have you ever wished you had...
2010-07-12
2,040 reads
SQL Server Agent – Proxy error
I was setting up some SQL Server agent jobs in a test environment. I needed one of our testers to...
2010-07-09
14,312 reads
SQL Bits 7 – The 7 wonders of SQL
I have been procrastinating this evening, I have several blog posts that I want to write but the football is...
2010-07-08
592 reads
DB2 – Create a Database
OK for my next DB2 trick and remaining off the path of the righteous for the time being we will...
2010-06-30
4,971 reads
2010-06-28
675 reads
Lock Pages in Memory
It is generally recommended that 'lock pages in memory' be enabled for your SQL Servers to prevent the OS paging...
2010-06-25
9,647 reads
24 Hours of PASS
On the 19th/20th May (last month) the Professional Association of SQL Server (PASS) held its second 24 hours of PASS...
2010-06-23
723 reads
Windows 2008 R2 Install Error - Using VMWare Workstation
Recently I was installing Windows Server 2008 R2 Enterprise Edition onto a virtual machine (VM) I was setting up to...
2010-06-22
2,307 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
Intermittent Service Freezes and "State 23" Authentication Failure
Environment: SQL Server: 2019 Enterprise (15.0.4430.1) OS: Windows Server 2022 Standard (Build 20348) Virtualization:...
SQL Server audit with windows ad group
I am trying to create a filter on a SQL Server audit to capture...
Deadlock graph anomaly
I've come across what appears to be a strange deadlock anomaly. As seen in...
Question of the Day
Deprecated Feature Tracking
From T-SQL, without requiring an XEvent session, can I tell which deprecated features are being used on my instance?
See possible answers