Pragmatic Works Foundation Class Oct 2011
I am super excited to announce that there is a strong demand for the Foundation Training to be held more...
2011-09-02
554 reads
Blog Posts
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,418 reads
Re-blog – August 26-September 1
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-02
660 reads
SQL Server test data generation testing tools
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
945 reads
Testing Decisions
One of the things I like to do is take some time on decisions that matter to me. That’s a...
2011-09-02
1,037 reads
Variables and Expressions with Connections in SSIS
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,504 reads
Geekbench 2.2 Released
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
945 reads
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
441 reads
Job Exit Planning Strategy
I feel somehow sad today (Aug 31, 2011) to see one of my colleagues “laid-off”. I put quotation mark around...
2011-09-01
1,895 reads
September Question: Tell us about your DBA interview experiences: good and bad.
I have only interviewed for a handful DBA jobs over the years, but they have ranged all the way from...
2011-09-01
651 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
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
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
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