Importance of Database Backups and Recovery Plan
As a DBA you need to ensure that the databases you manage are backed up regularly. This article details the importance of database backups and a recovery plan
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Introduction to DML Triggers
This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.
Showing OLAP Data in SSRS - SQL School Video
Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Can you shrink your SQL Server database to death?
To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
A methodology is described to bring out the best in database monitoring through System Center Operations Manager 2007 customization.
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