Steve’s tweets
- What’s a SQL Compare Snapshot? voiceofthedba.com/2017/09/21/wha… https://t.co/v6PasPJ4br 1 hour ago
- @jdanton going to the UK four times a year had helped me 11 hours ago
- @jdanton I'll work on my Celsius understanding. You convince everyone else 11 hours ago
The Redgate Livestream
Speaking at VSLive
Tags
administration auditing Azure backup Backup/Recovery blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly dbatools deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll Git hardware high availability Humor life Linux mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL in the City SQLNewBlogger SQL Prompt SQL Saturday SQLServer sql server SQLServerCentral syndicated T-SQL T-SQL Tuesday testing TopTenSkills training travel tsqlt vacation version control virtualization windows work
Tag Archives: T-SQL
The Code Coverage Report
I had someone that told me recently that they needed to find a way to get code coverage in T-SQL. Not for them, not to improve quality, but because their manager wanted a report. OK, here it is. First, build … Continue reading
Bulk Inserting Build Data–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the common tasks that many DBAs need to do is insert data into a database. Often this … Continue reading
Adding a New Default to a Column
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. This is a … Continue reading
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
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
FizzBuzz–#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’s been a … Continue reading
Move a Stored Procedure to a New Schema–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I needed to do recently was move an object. I was testing the WideWorldImporters database … Continue reading
Posted in Blog
Tagged security, SQLNewBlogger, syndicated, T-SQL
A Busy Few Years
Last week on Twitter, a friend mentioned they were submitting to the PASS Summit and went through their previous speaking engagements. This person noted they had done over 40 talks in the last few years, which is a lot. I … Continue reading
Limiting the Max–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was chatting with someone the other day about MAX() and how it can work within a set of … Continue reading
Posted in Blog
Tagged SQLNewBlogger, syndicated, T-SQL
Watch Your DataTypes in Aggregates–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve got a database of NBA statistics with data like this for players. I downloaded a CSV and loaded … Continue reading
Posted in Blog
Tagged SQLNewBlogger, syndicated, T-SQL
