June Question: How Do You Monitor Your SQL Servers?
As DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected....
2011-06-01
1,250 reads
Blog Posts
PASS Announces Pre-conference and Spotlight Sessions for PASS 2011 Summit
Today, PASS announced the Pre-conference and Spotlight Sessions for the PASS Summit 2011 in Seattle, which will run from October...
2011-06-01
1,106 reads
PerformancePoint wish list – change a datasource
One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid. There is...
2011-06-01
819 reads
Re-Focusing the Blog a Bit
In recent weeks I've strayed pretty much all over the map with respect to topics. I have another blog, the...
2011-06-01
744 reads
SQL Exercise During Candidate Interview Process
A discussion of how BPS uses a SQL exercise for candidates and why it is helpful.
At the Boston Public Schools,...
2011-06-01
2,711 reads
SQL Saturday Pensacola
I know it has been almost a month since I posted last and this is not really a “real” post,...
2011-06-01
432 reads
An Unexpected Service Gotcha
Recently I was participating in a round of storage rearranging with a client (aka the storage dance) which consisted of...
2011-05-31
1,555 reads
Free SQL Exam cram sessions from Microsoft.
G’day,
I’m a big fan of maintaining and updating your technical skills, but sometimes its difficult to measure your ability at...
2011-05-31
2,939 reads
How to protect code written in Stored Procedure or User Defined Function?
Introduction
We have always
been wondering on how to protect/secure our t-sql code written in Stored
Procedures and UDF in shared hosting environment...
2011-05-31
13,215 reads
Identity Reseeding
I love the identity property. I use it in many of my tables, mostly because it gives me a fairly...
2011-05-31
2,432 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Bank BCA KCU MENARA BCA Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat Bank BCA KCU THAMRIN Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec....
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers