SQLSaturday #85 - Orlando, Florida - September 24, 2011
Fortunately, SQLSaturday#85 stands in a class by itself - it's the only SQLSaturday scheduled this upcoming weekend in sunny Orlando, Florida.
Home...
2011-09-22
1,211 reads
Blog Posts
SSIS version in SQL Server
Integration Services is the management interface for SSIS packages. SQL Server uses the “MsDtsSrvr.exe” for executing packages
To highlight the point,...
2011-09-22
1,076 reads
SSRS – Dealing with truncating spaces
I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...
2011-09-22
2,072 reads
An Informal Compendium of SSAS Errors, Part 1: Introduction
When practicing for my MCTS in SQL Server Analysis Services (SSAS) 2008 R2 last spring, I was shocked to receive...
2011-09-21
1,480 reads
An Informal Compendium of SSAS Errors, Part 2: Data Mining
This is the first in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-09-21
2,249 reads
Context-sensitive menus in PerformancePoint
Frequently I see a bit of confusion from business users when using an analytic grid on a dashboard in PerformancePoint. ...
2011-09-21
662 reads
MicroTraining: Performance Tuning Checklist
I’ve been playing a lot with Google+ and the Hangouts there. I love them. I think they’re opening up a...
2011-09-21
1,011 reads
Replication DDL Triggers
Because this was a problem that Google was zero help on and I did find a couple other people afflicted...
2011-09-21
2,185 reads
September 2011 SQL Server 2008 Diagnostic Queries
Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information...
2011-09-21
794 reads
September Performance Contest
This month SafePeak is sponsoring a contest centered around improving performance in SQL Server. The host of the contest is my friend Robert Pearl. You can read the announcement...
2011-09-21
5 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers