Tag Archives: sql server

New Database Options

I saw recently that Azure SQL Database is getting a few more Database Scoped Options for that platform. These are intended to give more control over the way in which the engine behaves, without requiring each database on a server to function … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Republish: The Cost of Switching

Still on vacation. Enjoy The Cost of Switching

Posted in Editorial | Tagged , | Leave a comment

Setting Memory–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I had a great time away, and upon my return, I found lots of emails and messages to review … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Data Classification in SQL Server 2019

One of the areas that Redgate is working on is making data classification easier. Microsoft added some capabilities to SSMS 17.5 and Redgate has an EAP out for the next version of our data catalog tool. Azure SQL Database has … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

How does data file size relate to log file size?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. The other day I saw someone asking about a way to determine which databases have a log file larger … Continue reading

Posted in Blog | Tagged , , | Leave a comment

More than 25 Years for me

I was surprised to see a 25 year celebration for SQL Server at Ignite recently. It was also a 25 year celebration for Bob Ward. If you haven’t met Bob or seen him speak, make an effort to do so. … Continue reading

Posted in Blog | Tagged | 2 Comments

The Ever Expanding Data Platform

This past week was the 2018 Ignite conference from Microsoft, where we had a number of announcements about the data platform. You can rewatch some of the sessions from the event, and I might recommend the keynotes to see some of the … Continue reading

Posted in Editorial | Tagged , , , | Leave a comment

An Open Thank You to the Microsoft SQL Server Team

Thank you, Microsoft SQL Server Development team. I really am happy with your work. I was going through emails and noticed the someone had posted a surprise in the SQL Server 2019 CTP. The post was slightly cryptic, but since … Continue reading

Posted in Editorial | Tagged | 1 Comment

SQL Server v.Next is Coming in 2019

Yesterday the 2018 Ignite conference kicked off with a number of announcements from Microsoft. You can re-watch some talks and the keynote, catching up on Windows, CosmosDB, and more. The big announcement concerning most of us is about the next version … Continue reading

Posted in Editorial | Tagged | Leave a comment

How Do You Setup Your Instances?

I’ve set up a lot of SQL Server instances in my career. I’ve gone from manual only setup in SQL Server 4.2 to more automated means in the latest versions. The easiest was actually in Azure where I only need … Continue reading

Posted in Editorial | Tagged , | Leave a comment