Steve’s tweets
- Could that be @turbokenji ? https://t.co/nH9vq3zMrD 2 hours ago
- @spolsky my condolences. Losing a family member is always hard. 2 hours ago
- @jdanton Marshawn is a different cat 3 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
Monthly Archives: January 2017
Disabling #sqlprompt Formatting
I love SQL Prompt, especially the new formatting engine. However, it’s not perfect, and there are times I don’t want code reformatted. One great example is when I write INSERT statements. Here’s what I might write: INSERT dbo.Payments_A ( … Continue reading
Posted in Blog
Tagged Redgate, software development, SQL Prompt, syndicated
A Wide Variation in Skill
I was helping someone recently clear up some confusion about the encryption structure of their TDE databases. This individual wasn’t sure about how the various keys were used, which ones needed to be backed up, and which keys needed to … Continue reading
#ReadyRoll at #SQLintheCity
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source Control and DLM Automation work really well to bundle up changes in a VCS and easily deploy them. However, as … Continue reading
Posted in Blog
Tagged ReadyRoll, SQL in the City, syndicated
The New DBA is a Developer
I was reading a short piece from Mike Fal recently and it struck a chord with me. I started working with computers as a developer, really a hack programmer as a kid. Friends and I would build small games or … Continue reading
The vNext Bleeding Edge
Microsoft has had early access programs for years. I worked at a few companies that were a part of the TAP (Technology Adoption Program) program, and we would get access to code early in exchange for providing feedback and working … Continue reading
Posted in Editorial
Tagged Database Weekly, sql server
Finding Sysadmins with dba tools–GetDbaRoleMember
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. I have a short series on these … Continue reading
How Much Code Can You Review?
When I was in college, I mostly wrote my own code for assignments (and fun), turning it in when I thought it was done. At some point I had a class that started to adopt more software engineering practices, and … Continue reading
Posted in Editorial
Tagged software development
What’s a Database Encryption Key (DEK) in TDE
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran across a few people struggling to understand, so I decided to cover the concepts in a series of posts. This … Continue reading
The New SQL Server 2016 Edition Limits
I was thrilled with SQL Server 2016 SP1. I’ve been asking for all features to be in all editions for a long time, and now we have most of the features available. There are still a few enterprise only items, … Continue reading
Posted in Editorial
Tagged sql server
Querying My Named Instance in PoSh–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was looking at some sample code the other day and it looked like this. cd sqlserver:\sql\localhost\default\databases This allows … Continue reading
Posted in Blog
Tagged powershell, SQLNewBlogger, syndicated
