SQL Saturday - #74 - Jacksonville
Come attend this free one day training event in Jacksonville, FL on Apr 30, 2011. Meet a number of SQL Server experts and learn about SQL Server at the University of North Florida.
TOP 10 SQL Server Requests That Should Be Automated
What DBA wouldn't want to make their job a little easier?
DBAs on ACID
Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.
Real World Foreach Loop Container example
Describes different uses of the SSIS Foreach Loop container in one practical scenario.
The Value of Data
What value can you place on data? It can be hard to determine, especially when so many sites on the Internet want data to be free. However the New York Times is going to a subscription model, with the idea that there is some value to their data and people will pay for it.
TSQL Challenge 53 - Finding empty and non-empty intervals
A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in.
SQL Server Service Broker Poison Message Handling
Have you ever figured out why your Service Broker queue gets disabled automatically? What causes your Service Broker queue to get disabled in the first place? What is a poison message with respect to Service Broker? Is there anything new in SQL Server 2008 R2 for managing poison messages in Service Broker?
The DBAs Guide to Expectation Management
Your customers expectations are their primary measure of your success. How well are you managing them?
You’re reading The DBAs Guide...
Improving SQLServerCentral
Today Steve Jones talks about changes that are coming to SQLServerCentral.
Open Source SQL Server
There's a new product out that is an alternative to Microsoft SQL Server. The new HummyBase product from Kenneth Ingols SQL Software gives you another platform for your databases applications with no re-coding and at a fraction of the price.
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 Taman Palem Lestari Telp:cs.(0821)8171955
Whatsapp:08218171955 Komp. Perum Jl. Taman Palem Lestari No.C5 No. 9 -11, Cengkareng Bar., Kecamatan...
BCA KCP Sentral Cikini Hub:Cs.083831618816
WhatsApp:083831618816 Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCP Pangeran AntasariTelepon 083110611866
WhatsApp 083110611866Jl. P. Antasari No.130Tanjung, Baru, Kec. Kedamaian, Kota Bandar Lampung, Lampung 35131
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