T-SQL Tuesday #005: Smart Card Login Breaks SQL Server 2008 Reporting Services
T-SQL Tuesday #005: Smart Card Login Breaks SQL Server Reporting Services 2008
This blog entry is participating in T-SQL Tuesday #005,...
2010-04-13
3,423 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
5 Random Thoughts on the SQL Server MCM Program
5 Random Thoughts on the SQL Server MCM Program
I've had some random thoughts running through my head since I finished...
2010-04-10
3,504 reads
2010-04-10
585 reads
How do I ... Write a Backup Strategy?
How do I Write a Backup Strategy?
DBA's harp about the need to have backups. The first thing many DBA’s do when they inherit...
2010-04-09
962 reads
Catching Transient CPU Spikes Using SQL Trace
Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...
2010-04-06
4,519 reads
SQL Server 2008 MCM Results
SQL Server 2008 MCM Results
3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam....
2010-04-04
1,435 reads
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
12,066 reads
Measuring Transactional Replication Latency Without Tracer Tokens
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,069 reads
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-17
1,763 reads
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,698 reads
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers