SQL Intersection 2013 – Las Vegas in April
It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots...
2013-02-01
1,231 reads
Blog Posts
SQL Server 2012 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,001 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,138 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,267 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
423 reads
Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,844 reads
How to find/modify SQLServer Agent logfile location?
1. To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out
DECLARE @AGENT_ERRORLOG NVARCHAR(255)
EXECUTE MASTER.DBO.XP_INSTANCE_REGREAD N’HKEY_LOCAL_MACHINE’,
N’SOFTWAREMICROSOFTMSSQLSERVERSQLSERVERAGENT’,
N’ERRORLOGFILE’,
@AGENT_ERRORLOG...
2013-01-31
7,735 reads
I'm an Administrator Why Can't I Copy Files
Hello Dear Reader! I've been working on setting up a virtual environment for quite some time. When last I wrote...
2013-01-31 (first published: 2013-01-24)
2,794 reads
Querying Execution Plan XML For Inaccurate Row Count Estimates
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...
2013-01-31
1,880 reads
SSRS 101 – Creating a Shared Data Source
In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how...
2013-01-31
2,561 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers