Using Tools That Fit
The right tool is important for a good job. Andy Warren asks if you're thought about the tools you use on a daily basis.
Using Azure Quickstart Templates
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
Selling Automation to Ops
Steve Jones thinks that DevOps is the wave of the future for most companies. He has a few ways to try and bridge the gap between development and Operations groups.
Using Redgate API to compare data in the same table
I needed to speed up some regression testing. Redgate Sql Data compare API helped me do it.
Configuring a MySQL Database on Amazon RDS
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
Being Careful with Schema Ownership
When you create a schema, you might accidentally make yourself the owner, which can cause issues later. Learn how to ensure that your schemas aren't owned by transient employees.
Modeling and Design Are More Important in DevOps
Steve notes that modeling and good database design can't be ignored in DevOps work.
A Primer on Defect Management
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
The Importance of Consistent Server Setup
In larger shops with multiple database servers, it is very important to have consistency.
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers