Steve’s tweets
- @BeginTry @Jorriss imdb.com/character/ch00… 7 hours ago
- @BeginTry @Jorriss Willie Beamen 7 hours ago
- @Jorriss Cheered for the Yanks when they were bad, same for the Broncos 7 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: sql server
A SQL Server Bug and Data Security
This week I saw a post from Microsoft Tiger Team on the issues with backup compression and TDE databases. Apparently when they added compression, they didn’t test a few edge cases. Or a few regular cases, like WITH INIT. There … Continue reading
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
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
SSoL: Where are my data and log files?
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
Getting Close to the 2017 RTM
I still can’t believe that we’ll have a new version of SQL Server this year. After speaking at so many events last year, talking about the new features of SQL Server 2016, it seems crazy that there’s a new version … Continue reading
SQL Server 2017 RC1 is Here
And I’ve got it. Glenn Berry posted a a link to the MSDN blog and almost immediately a note that the link was still the CTP. I decided to fire up my Ubuntu install and check. No updates there, though … Continue reading
Database Mirroring Needs FQDNs
A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes. I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the … Continue reading
Posted in Uncategorized
Tagged administration, high availability, sql server, syndicated
Leave a comment
SQL Server is Lagging a Bit
I don’t expect this to last, or I hope it doesn’t, but SQL Server is lagging behind. I ran across a short piece on the SQL:2016 standards, and I know these standards aren’t necessarily an important consideration for most of us when choosing … Continue reading
Adding Performance Counters back for SQL Server
I had a strange situation the other day, where a number of things went wrong with my instance. First, I lost permissions to detached databases. The SID was listed in the file permissions, but apparently unlinked to an account. Next, … Continue reading
Posted in Blog
Tagged administration, sql server, syndicated
Using OPENROWSET in SQL Server on Linux
I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the SQL to allow you to use this with the graph database features. However, it’s built for Windows. Linux is a … Continue reading
