Search this blog
Steve’s tweets
- @AndyLeonard to some 13 hours ago
- I'm not very interesting today https://t.co/G30hAU3lNe 15 hours ago
- A Problem with POWER() voiceofthedba.com/2018/11/20/a-p… 16 hours ago
Friends of Redgate
MVP Award
Tags
- administration
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- bloopers
- business
- Business Intelligence
- career
- career
- cell phone
- Cloud Computing
- computers
- continuous delivery
- continuous integration
- data
- data analysis
- database design
- databases
- Database Weekly
- dbatools
- deployment
- Dev Connections
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- 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 Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- SQLServer
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- training
- travel
- tsqlt
- vacation
- version control
- virtualization
- webinar
- windows
- work
Monthly Archives: January 2012
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a client front end, you can easily encapsulate your insert in a stored procedure and then SELECT scope_identity() to get the … Continue reading
Should we outsource identity management
My Database Weekly editorial for Jan 30, 2012 One of the first things many people build when they’re developing an application these days on the web is a login/identity system for their users. This allows them to identify people, customize … Continue reading
Posted in Editorial
Tagged Database Weekly, security, software development
Morale Data
Would you use this site to enter your morale at work? It’s an idea by a new company that should enable employees to enter information about how they feel at work, how their job is going, and other meta data that describes their attitude … Continue reading
A Quick Export with SQL Packager
Disclosure: I work for Red Gate Software Someone asked me the other day if I’d ever used SQL Packager to export a table to send to another person. I hadn’t, and in fact hadn’t even ever run the tool, but … Continue reading
Healthy Work Habits
Many of us work with computers extensively, day after day. It’s easy to fall into the habits of working in a particular way, and we’ve seen recommendations from health professionals about the dangers of our environment. I’ve written in the past … Continue reading
Enabling Compression? Update your baseline
I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me that compression can dramatically affect your baseline, and as you implement it, or de-implement it, you need to update your … Continue reading
Posted in Blog
Tagged administration, sql server, syndicated
No Cloud for Stack Exchange
One very large and successful site in the technology world is the Stack Exchange collection of sites. They’ve grown and scales with relatively few people, and they have chosen to host thier own systems as opposed to moving to the … Continue reading
Posted in Editorial
Tagged career, Cloud Computing
The Avon Walk
It’s more often than not that I wake up, hoping that no new bad news comes my way. The short story is that my wife is going to do a 39mi walk this summer to raise money for cancer. If … Continue reading
Back to Vegas
I enjoy Las Vegas and am glad to be heading back to present at the Spring SQL Server Connections conference in March. If you wear a number of hats at your job, and deal with a variety of platforms in the Microsoft … Continue reading
Posted in Editorial
Tagged conferences, speaking
Insert multiple rows from one INSERT statement
One of the things that has been annoying for a long time in SQL Server is adding lots of data for testing. Personally I use Data Generator, and I recommend that, but for a quick few rows of data, do … Continue reading
Posted in Blog
Tagged sql server, syndicated, T-SQL
