SSIS – Adding Connections
Sometimes you get reminded that you don’t know everything about SQL Server and it’s various products Every time I run...
2017-04-27
559 reads
John Morehouse | Sqlrus.com
Quick Script: Finding Specific Columns
I like scripts. Scripts that help me do things.
Working in the financial industry, there are always things that you have...
2017-05-04 (first published: 2017-04-25)
1,453 reads
I’m Speaking! Code PaLOUsa!
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
359 reads
T-SQL Tuesday #89 – There is No Cloud
T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community It is the brainchild of Adam Machanic (B|T)...
2017-04-11
322 reads
Schedulers To Rule Them All
Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled. This...
2017-03-17
778 reads
May MVP – Bob Pusateri
Whoa. I’m way behind in my blogging.
For the month of May, my MVP choice is Bob Pusateri (B|T).
Bob is a...
2016-10-06
438 reads
I’m Speaking! SQL Saturday #548 – Kansas City
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. This particular event is like going home...
2016-09-22
449 reads
Quick Script – Finding Most Recent Backup
Recently I have had to restore a number of databases into our training environment. Looking up each backup individually would...
2016-09-27 (first published: 2016-09-19)
1,314 reads
April MVP – Chris Yates
The April MVP nomination is Chris Yates (B|T).
Chris is one of those individuals that always have a positive outlook on...
2016-04-28
872 reads
Changing Of the Guard
As many of you know, I stay very active within the PASS community. In late 2007 I got my start,...
2016-04-14
486 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
How to Repair Corrupt MySQL Tables
Comments posted to this topic are about the item How to Repair Corrupt MySQL...
The Funny Dynamic SQL
Comments posted to this topic are about the item The Funny Dynamic SQL
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers