(Pinal Dave) Team database development is hard. It throws up questions about who’s responsible for code, how to track changes, and how to share them. For application development, teams can overcome these problems with version control. Databases are different.
Tag: sql server
Stopping your SQL Server Job
(Chris Shaw) Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There is going to be times when you are going to need to run maintenance on your server.
The Internals of WITH ENCRYPTION
(Paul White) It is pretty easy for a SQL Server administrator to recover the text of stored procedures, views, functions, and triggers protected using WITH ENCRYPTION. Many articles have been written about this, and several commercial tools are available.
SQL Server Security Audit Basics
(Feodor Georgiev) SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use because it lacks centralization and analysis tools. It can do a fast and lightweight audit of many different activities including DML and DDL at both Instance and Database Lev
Troubleshoot SQL Server Agent Notifications and Database Mail
(Varinder Sohal) Recently when we came into the office and started reviewing daily alerts and we found that one of our business critical production environments did not send an alert for one of the critical SQL Server Agent Jobs. This SQL Server Agent Job feeds data to our FINANCE application dashbo
SQL Server Service Broker – Error Handling
(Colleen M. Morrow) This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database Engine.
Easy SQL mistakes: Accidental Correlated Subquery
(Jen McCown) Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup (you knew it had to be Minion related, didn’t you?) and I just got the oddest error. Here’s how it went.
How do I rename a column?
(Kenneth Fisher) Everyone makes mistakes right? And sometimes you create an object and decide later that you messed up and need to rename it.
Can’t RDP to Azure VM?
(Gethyn Ellis) I ran into an interesting problem early this month. I was spinning up an Azure VM with SQL Server 2016 RC0 on it. For testing purposes. Looking at Stretch databases a new feature in SQL Server 2016
SSRS report for SQL Server Database Backup Status
(Scott Murray) I have a lot of databases to backup and I need a SQL Server Reporting Services (SSRS) report to show the backup status. What options are available? What is the most important data?