An In-Depth Examination of Red Gate SQL Monitor
A review of SQL Monitor, the new DBA utility from Red Gate Software that can help you keep an eye on what your SQL Server instances are doing.
Careful Blogging
Today we have a reprint of an editorial from Sept 22, 2005. In this one, Steve Jones reminds you that blogging is a public event and you want to be careful about what you write.
Avoid External Dependencies in SQL Server Triggers
I sometimes want to perform auditing or other actions in a trigger based on some criteria. More specifically, there are a few cases that may warrant an e-mail; for example, if a web sale takes place that requires custom or overnight shipping and handling. It is tempting to just add code to the trigger that sends an e-mail when these criteria are met. But this can be problematic for two reasons: (1) your users are waiting for that processing to occur, and (2) if you can't send the e-mail, how do you decide whether or not to roll back the transaction, and how do you bring the problem to the attention of the administrator?
SQL Saturday #47 - Phoenix
Come learn about SQL Server in Phoenix on Feb 19, 2011. For free! Spread the word to anyone you know in the area.
Most Work is Mundane
Today we have a guest editorial from Andy Warren. Work can seem mundane and tedious at times, and today Andy asks you you remain engaged when the work isn't exciting.
Preventing usage of "SELECT *..."
Is there a way to not allow users to use SELECT * in their queries? New author AJ Raghuram has an interesting solution that can prevent this in code.
SQL Server Data Mining with Microsoft Office Excel
This article demonstrates using SQL Server's data mining capabilities with the Excel.
SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
OldSQL
Support for SQL Server 2005 expires in April. Should you care? Steve Jones thinks it might not be a big deal for many people.
February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries
Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information...
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
The Vector Data Type
Comments posted to this topic are about the item The Vector Data Type
What Power BI DirectQuery does to your SQL Server (and how to fix it)
Comments posted to this topic are about the item What Power BI DirectQuery does...
The New OS Wars
Comments posted to this topic are about the item The New OS Wars
Question of the Day
The Vector Data Type
What is the vector data type in SQL Server?
See possible answers