Steve’s tweets
- @SQLSoldier do it, they are in source control, right? 2 days ago
- Loading All CSV Files with PowerShell voiceofthedba.com/2017/06/23/loa… https://t.co/8BbCuMSMau 2 days ago
- Nice to see security is a popular developer topic at @denverdevday https://t.co/Chu8Pwm4fC 2 days ago
Speaking at VS Live – Austin
Register with AUSPK14 and save $400
Tags
administration auditing Azure backup Backup/Recovery big data blogging bloopers business Business Intelligence career career cell phone Cloud Computing computers conferences continuous delivery continuous integration data analysis database design databases Database Weekly deployment Dev Connections DevOps disaster recovery DLM encryption Filetable Friday Poll hardware high availability Humor hyper-v life mcm Microsoft misc monitoring networking NoSQL PASS patching Performance powershell presentations Redgate sabbatical security software development software development speaking SQL Bits SQL Connections SQL Intersection 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: administration
The Need for DRE
“Today’s database professionals must be engineers, not administrators” That’s a quote from an interview at O’Reilly on Database Reliability Engineering. I don’t want to quibble about whether those of us working in technology are engineers in name or not, but … Continue reading
Renaming MDF/LDF Files–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I would guess many people would run into this situation at some point. A developer or DBA creates a … Continue reading
Why Does My Log Grow–SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a great topic, and really, every DBA or admin should blog this and be sure they understand … Continue reading
SQL Server is Getting Smarter
There’s been a lot of press and media about Microsoft on the AI and machine learning work they’re heavily investing in. From Cognitive Services to Cortana to Bots, Microsoft is really investing in developers and applications that will perform detailed … Continue reading
Restore to a point in time–#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. One of the … Continue reading
Posted in Blog
Tagged administration, Backup/Recovery, sql server, SQLNewBlogger, syndicated
1 Comment
Using DBCC Clonedatabase
I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this: On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo … Continue reading
Balloons and Data
This editorial was originally published on Aug 8. 2013. It is being re-run as Steve is out of the office. We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some … Continue reading
Using Trace Flags
At SQLServerCentral, we recently published a list of all the trace flags from Konstantin Taranov. It’s a great list, and thanks to Konstantin for compiling it. While I haven’t often used trace flags, there are some that have really helped … Continue reading
Posted in Editorial
Tagged administration, sql server
Global v Session Trace Flags
I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss the implications of session v global trace flags, which is something I’d like to do here. In the article, I … Continue reading
Posted in Blog
Tagged administration, sql server, syndicated
Backups Aren’t Backups Until a Restore Is Made
One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading
Posted in Editorial
Tagged administration, backup
