|
Category: Uncategorized
#TSQL2SDAY (8) Administration (41) AI (2) AlwaysOn Availability Groups (11) Azure (12) Career (25) Community (37) Continuous Integration / Deployment (7) Development (12) Disaster Recovery (27) General (20) High-Availability (9) Microsoft SQL Server (20) Performance (30) PowerShell (12) SQL Agent (8) SQL Server Management Studio (2) SSAS (1) SSIS (1) SSRS (2) T-SQL (14) Uncategorized (191) Windows Clusters (7)
-
Broken ownership chain – Dynamic SQL
/
Today I had a co-worker come to my desk wondering why his service was getting a permissions error when selecting from a table. His…
-
Don’t feed the monkeys 3 ways to help people solve their own problems
/
I have struggled to learn how to stop feeding the monkeys for quite some time. I’m happy to see that commitment is being listed…
-
Information Technology: Minimum requirements
/
I’ve been asked, several times, what skills a person should work on if they wanted to enter the IT field. The specific question changes…
-
SQL Server 2012 SP2 released
/
Microsoft SQL Server 2012 SP2 is now available Build number: 11.0.5058.0 > Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions…
-
Update zero base column to one base
/
Problem: A co-worker requested help with a query today… Derik, I have an Email table with a list of email addresses per person record. There…
-
What happened to the SQL Hammer?
/
Two months ago I accepted a new position as a Data Architect / Developer (SQL and .NET). I accepted the position partially due to my…
-
FILESTREAM garbage collection with AlwaysOn Availability Groups
/
It seems that, of the DBAs who use FILESTREAM, it is common to ask, “why do I have more file system objects then I…
-
My Epic Life Quest
/
As a child I watched television and watched movies. The influence of the shows I watched on me is undeniable. It didn’t take much…
-
SQL Server 2014 RTM – Release Date
/
Today, Microsoft announced that SQL Server 2014 RTM will be generally available on April 1st, 2014. In addition to this wonderful piece of information;…
-
Session review – Brent Ozar at RSSUG
/
Yesterday (Friday, March 14th, 2014) Richmond, VA’s SQL Server user group was fortunate enough to have Brent Ozar ( @BrentO | BrentOzar.com) stopped by…