Steve’s tweets
- A SQL Server Bug and Data Security voiceofthedba.com/2017/09/23/a-s… 17 hours ago
- @SQLvariant enjoy. Keep the little guy smiling 20 hours ago
- RT @redgate: We're #hiring a Product Marketing Manager - interested? Here's what life's like as a Redgate marketer. rd.gt/2ywukcf 20 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: November 2012
Staging Deployments
Software development can be a complicated dance. Most of us do not work for a software vendor and don’t have the strict requirements for our deployments when we control the client systems. That doesn’t mean it’s easier for us, especially … Continue reading
SQL Server Thumbnail Metrics – OS Memory
I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to run a SQL Server. This is a series of posts that I’m making to gather these metrics up for easy … Continue reading
Don’t Explain Too Much
I was reading a note recently from a DBA working at a software company. Their management wanted to ensure clients had a simple backup solution and were leaning towards Windows OS backup instead of SQL Server backups. They were planning … Continue reading
Regulators, Mount Up
I have an encryption talk that I give and usually find a few people in the audience that have implemented encryption. In almost every case this has been because of PCI or HIPAA regulations that dramatically reduce penalties if data is encrypted. … Continue reading
Posted in Editorial
Tagged auditing, security, sql server
The Last DBCC CHECKDB Date and Restores
I ran across a question on Twitter recently where someone asked about the DBCC CHECKDB date after a restore. For those of you that don’t know this, you can run this command on your instance (in a database) DBCC DBINFO … Continue reading
Targeted Learning
I received an email just after I arrived in Seattle for the last SQL in the City 2012 stop. It was from Simon Doubt, who was also coming to Seattle for the PASS Summit, but who hadn’t planned on just … Continue reading
How Application Roles Work in SQL Server
One very interesting security technique available in SQL Server is the application role. It’s an interesting way of applying security to a user, and perhaps a way of preventing users from accessing data with unauthorized applications. An application role is … Continue reading
Review Your Indexing
In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading
Posted in Editorial
Tagged indexing, sql server
Locking Your Disk
This editorial was originally published on Feb 28, 2008. It is being re-run as Steve is on holiday. With the tremendous growth in disk sizes and the trend towards more and more people using laptops, someone sent me a note … Continue reading
Posted in Editorial
Tagged encryption, security
Happy Thanksgiving
It’s Thanksgiving in the US and I’m in the mountains of Colorado enjoying the holiday while skiing with my family. Hopefully many of you are having a quiet day if you’re at work, or enjoying the day off if it’s … Continue reading
