November Question: What steps do you include in your database maintenance?
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-01
1,438 reads
Rescheduled: SQL Lunch #42 - Auditing Database Permissions in SQL Server
Last Wednesday I woke up feeling under the weather with a hoarse voice. I wasn't up to doing the presentation...
2010-11-01
709 reads
Leaving (for) Las Vegas
Tomorrow I’m off to Las Vegas for SQL Connections. Since tomorrow is also T-SQL Tuesday #012, I’m writing a pre-trip...
2010-11-01
429 reads
“Wear Your SQL Saturday Shirt Day”
Over the past year there have been a number of SQL Saturday events. These events have occurred across the country...
2010-11-01
878 reads
Vote for Our SQL Rally PreCon
VOTE VOTE VOTE VOTE VOTE VOTE VOTE!!!!!!!!!!
Vote here: http://www.zoomerang.com/Survey/WEB22BD59JCQBT
Honestly, I want each of reading my blog to vote for our...
2010-11-01
491 reads
SQLServerCentral.com Track at SQL Server Connections This Week
If you are attending SQL Server Connections this week in Las Vegas, be sure to attend some of the sessions...
2010-11-01
630 reads
Database Security Best Practices for the Vigilant Database Administrator and Developer (Unabridged Edit)
Below is a longer version of the equivalent Technet Article under Security TechCenter > Learn > Security Columns > MVP Articles > Database Security Best PracticesThe security of...
2010-10-31
5,327 reads
Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in...
2010-10-31
1,668 reads
I’m starting my own SQL Server Consulting business!
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,538 reads
Why do you use Sparse Columns ? (by Abi Chapagai)
What uses have you found for sparse columns in your databases?
SPARSE columns is a new feature in SQL Server...
2010-10-31
2,602 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Alamat Kontak Bank BCA KCP Ancol Telp:(0817819444)
WhatsApp:0817819444 Blok A VI No, Jl. Parang Tritis Raya 3B-3C, RT.8/RW.11, Ancol, Kec. Pademangan,...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers