Database Growth
Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly...
2015-05-14
753 reads
John Morehouse | Sqlrus.com
Free Your Mind. Release Your Inner Developer
I have always liked the drawings done by MC Escher. Looking at his drawings has always forced me to look...
2015-05-07
416 reads
SQL Saturday 392 – Atlanta, GA
Have you been to Atlanta, Georgia ? Nope? Well it’s time you plan that trip and come see me speak May...
2015-04-30
960 reads
Quick Script: Finding Database Owners & Security Admins
Security Is Everybody’s Responsibility
Recently, while diagnosing a permissions issue on a Production database, I realized that I didn’t really have...
2015-04-23
349 reads
2015 Program Committee
Last year, I was very much honored to be selected to deliver a pre-con with my friend brother Chris Shaw (B|T). I...
2015-04-16
408 reads
T-SQL Tuesday #65 – Failing Over with PowerShell
This month’s T-SQL Tuesday topic is being hosted by Mike Donnelly (B|T). The topic of choice is a fantastic one,...
2015-04-14
657 reads
Detaching a Database – File Security Gotcha
I’ll admit it, there are times where detaching a database is the best way to get something accomplished, but it...
2015-04-09
661 reads
Procedure Creation – Correct Syntax, Wrong Database
Recently, on a Friday evening, we released an update to one of our core applications. As expected, it went smoothly...
2015-04-02
421 reads
Database Restores – Zeroing Out Log Files
I recently came across a question on the #sqlhelp Twitter feed that I thought was interesting. The question pertains to...
2015-03-26
438 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...