World Backup Day
This Saturday is World Backup Day, and with this in mind, Red Gate's Brian Harris talks about SQL Backup 7 and why they want to make backup verification a focus for more DBAs.
The Mechanical Turk
Today's editorial was originally published on Apr 17, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks about the Mechanical Turk process at Amazon.
A Variety of SQL Rally Pre-Cons
The 2012 SQL Rally is coming in May to Dallas, TX and there are a number of pre-conference sessions that can help you learn about something that interests you at an inexpensive price.
Get Back into SQL Server After You've Locked Yourself Out
Someone, while locking down the SQL Server, removed the permissions by which the DBAs came in and administered the server. As a result, we cannot get back into SQL Server. How can we restore our access to SQL Server? Check out this tip to find out.
Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS
This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.
Is Computer Science Dead?
Today's editorial was originally published on Apr 27, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve talks programming.
SQL Server Indexing Best Practices: Stairway to SQL Server Indexes Level 15
Dos and don’ts that lead to a healthy, well-performing database.
Vendor Selection
Today's editorial was originally published on Apr 29, 2007. It is being re-run as Steve is at SQL Server Connections. Today Steve Jones talks about purchasing software.
Storing E-mail addresses more efficiently in SQL Server
A lot of people are storing large quantities of e-mail addresses in their systems. Since a large percentage of any system's user base is going to be supplying e-mail addresses from a few of the vastly popular providers (such as GMail and Hotmail), we are storing the "@gmail.com" and "@hotmail.com" parts of those addresses on disk over and over and over again.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Wahid Hasyim Telpon/WA:087768193341
BCA KCP Wahid Hasyim Telpon/WA:087768193341.Jl. K.H. Wahid Hasyim No.82, Kb. Sirih, Kec. Menteng, Kota...
BCA KCP Raden Saleh Telpon/WA:087768193341
BCA KCP Raden Saleh Telpon/WA:087768193341.Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota...
BCA KCU THAMRIN Telpon/WA:087768193341
BCA KCU THAMRIN Telpon/WA:087768193341.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers