Data Privacy Summit
Search this blog
Steve’s tweets
- @tjaybelt Thx, would love to see it. Be nice to see why/how you did it, then maybe a short second piece on using th… twitter.com/i/web/status/9… 3 hours ago
- @tjaybelt I was hoping for a more formal writeup. Rather than the tweet so you could go back to hammock building. 3 hours ago
- @sqlstudent144 very nice 3 hours ago
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
- 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 Clone
- SQL Connections
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServer
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- testing
- TopTenSkills
- travel
- tsqlt
- vacation
- version control
- virtualization
- windows
- work
Monthly Archives: May 2015
Statistical Analysis
I ran across a book recently that is written to address some of the statistical issues the author has found in many scientific papers. It’s been released online for free, but if you like it and would like a more portable … Continue reading
Posted in Editorial
Tagged data analysis, Friday Poll
The Hidden Patterns in Data
There’s a great TED talk on statistics, and one I’d recommend you watch. However, it’s not so much the topic and data presented, but the way in which it’s presented and broken down that becomes interesting. If we ignore the topic, … Continue reading
Posted in Editorial
Tagged data analysis
Visualizing the Tally Table
I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have … Continue reading
Who Am I?
I saw Brent Ozar updating his About Me slide, and thought it was interesting. Not sure if I like what he’s done, but it’s different, which usually attracts attention. I updated mine last year, with some help from the people … Continue reading
Changing NULL to NOT NULL – Dealing with Data
I wrote recently on how to alter a column in SQL Server from NULL to NOT NULL in a simple way. However I didn’t cover some of the cases where you have data in the column, or other restrictions that … Continue reading
Posted in Blog
Tagged syndicated, T-SQL
Unit Testing in Philadelphia
I’m helping teach a pre-conference session on Friday, June 5, 2015 at the Microsoft office in Philadelphia. This is an all day, paid for event, that looks at how you can use a framework to write unit tests for your … Continue reading
Posted in Blog
Tagged SQL Saturday, syndicated, testing, training, tsqlt
Native Audits
As our databases contain more and more information, it is becoming increasingly more common to implement some sort of auditing feature to ensure that our data is not being inappropriately accessed or altered. It’s not only the management of our … Continue reading
Posted in Editorial
Tagged auditing, sql server
DB_Owner Querying for Database Options
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, … Continue reading
Posted in Blog
Tagged administration, sql server, SQLNewBlogger, syndicated
Naming Confusion
When I first worked in a corporation that had many servers, I had to learn the encoding of our systems. We had SUIS01, SUIS02, NAIS01, NAOP01, etc. Each name designated a location and department, but no information as to what … Continue reading
Posted in Editorial
Tagged administration, sql server
Controlling Alerts
None of us likes to be on call for our organizations. Late night phone calls, especially for something silly like adding a new user to a system or rebooting a machine, can make for irritable employees in the morning. Too … Continue reading
Posted in Editorial
Tagged administration, sql server
