PASS Summit 2018 – Keynote Day 1 Live Blog
Today is the first full day of the PASS Summit in Seattle, Washington. This is the 20th year of the...
2018-11-07
318 reads
Tim Mitchell
Where Are Your Data Leaks?
It has been almost impossible to avoid reading about the numerous large-scale data breaches reported on a seemingly daily basis....
2018-10-02 (first published: 2018-09-25)
1,953 reads
Speaking at PASS Summit 2018
I am honored to have been selected to be a presenter at this year’s PASS Summit coming up this November....
2018-06-06
293 reads
Temp Tables in SSIS
Temp tables are very handy when you have the need to store and manipulate an interim result set during ETL...
2018-05-29
461 reads
Managing Business Logic
Encapsulating business logic into data movement and presentation is a critical part of a stable information management strategy. Too often,...
2018-05-17
301 reads
Trading Data For Convenience
If data is the new oil, then the web is the world’s biggest gas station. Every day a few billion people...
2018-05-08
270 reads
Using SQL Server Management Studio Projects
One of the most underutilized assets in SQL Server Management Studio is the SSMS project. Within Management Studio, one can...
2017-12-22
546 reads
A Business Lesson from an Oil Change
When I first moved to the city where I now live, I found an oil change place just a couple...
2017-12-21
384 reads
Making a Difference: Andy Warren
Since I started working as a data professional some 15 years ago, I’ve had an enjoyable and successful career. I...
2017-12-20
352 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
397 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