SQL Server “Denali”: Details on the next version of SSAS
At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. ...
2011-06-27
3,187 reads
Blog Posts
SQLDIY: Tracking Wait Stats
One of the most important methodologies to date for troubleshooting problems with the SQL Server engine is examining the wait...
2011-06-27
1,056 reads
Where Do You Go for Authoritative SQL Server Best Practices?
Reprinted from my editorial in Database Weekly.
In early 2000, I started a new DBA job with a large organization, as...
2011-06-27
934 reads
Why Two Devices
I used to travel with two laptops, one as a backup, however lately I’ve switched to taking the iPad and...
2011-06-27
923 reads
LulzSec: Why You Should Care
Updating Resume is NOT Lulz
Wow, it’s been a crazy last couple of months with LulzSec running around doing what they...
2011-06-26
1,519 reads
ALTER TABLE - Adding Column - Column Order Impact
Most of us would have altered a table structre by adding a column to the table. When an ALTER table...
2011-06-25
980 reads
Who Am I
If you’re anything like me, you use many different machines on a daily or sometimes weekly basis. Some of these...
2011-06-25
688 reads
Configuration Manager for Sqldiag
SQLdiag is a diagnostics collection utility to collect logs and data files from SQL Server that you can use to monitor...
2011-06-24
1,115 reads
Five Lines of Code
An interesting story on how a database speeds up by changing some application code. Worth the read for sure.
I caught...
2011-06-24
784 reads
Full Time Employees Per Number of Database Users? FTE/DB users? How Many Servers are too much to Handle?
After several days research, I have been trying to get a rough estimate on how many Full Time Employees are...
2011-06-24
3,248 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 BCA KCP Telepon Kota Telp:08218154393
WA:08218154393 Jl. Ps. Pagi Raya No.9, RT.2/RW.2, Roa Malaka, Kec. Tambora, Kota Jakarta Barat,...
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers