Tag Archives: syndicated

Using Merge–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was playing with some data, loading it into staging tables and then moving it to a real table. … Continue reading

Posted in Blog | Tagged , , | Leave a comment

T-SQL Tuesday #93–Interviewing Patterns

It’s time for T-SQL Tuesday, and this is a good topic. Not too close to T-SQL, but certainly something many people are interested in. Kendra Little hosts this month, and her topic is interviewing patterns and anti-patterns. Things that are … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The 2017 Data Platform Summit

I’m off in a couple days to India for a week of vacation and then the 2017 Data Platform Summit. This is my first time attending, and I’m excited to go. A new country to visit and present in. In … Continue reading

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

Checking Your Database Properties–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was reading Grant’s Database Fundamental Series on Database Properties, and it got me thinking. I think this is … Continue reading

Posted in Blog | Tagged , , | Leave a comment

MSBuild and Azure SQL Database

I saw a report of a problem building a database with ReadyRoll in Azure SQL Database. This person wanted to use a local Shadow database in LocalDB and target an Azure SQL Database. I hadn’t build that config, so I … Continue reading

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

SSoL: Adding disk space with a repartition

I don’t think most of us need to know Linux, but if you end up managing a system, it’s good to have a little idea of how to get around. This is a short series of posts as I remember … Continue reading

Posted in Blog | Tagged , , | 4 Comments

Backup Log to Nul– #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. There are times … Continue reading

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

Using Test-DbaOptimizeForAdHoc

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. One of the cmdlets is Dba-OptimizeForadHoc, which … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Azure Labs–Minor Cluster Issues for SQL Server Setup

During the process of building an Azure lab, I ran into a place where my cluster was not completely validated. I think this happened when a node failed and was re-provisioned, but in any case, when I ran SQL Server … Continue reading

Posted in Blog | Tagged , , | Leave a comment

DevOps–Fixing Poorly Named Constraints

I was building some code the other day and kept getting problems in my deployment for a change. The deployment was having issues, and this came down to this statement. ALTER TABLE EventLogger DROP CONSTRAINT [PK__EventLog__5E548648B043C0BC] The problem was that … Continue reading

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