SQL Saturday 769 Melbourne & 771 Sydney

For those not aware there’s some excellent local SQL events coming up here in Melbourne and Sydney…
SQL Saturday769 (Sat 30 Jun 2018)...

Birthday Musings and Deploy Using PoshSSDTBuildDeploy

Hello!

It is my birthday: another year older, another year not necessarily wiser. I’m planning on spending the evening watching the BBC and eating pizza. There are worse ways to...

Lost that SQL Server Access?

Losing access to a SQL instance is never a desirable situation - for the DBA. When the people that are supposed to have access, lose that access, all hope...

Lost that SQL Server Access?

As a data professional can you recall the last time you needed to support a SQL Server instance for which...

The Importance of ORDER BY

Everyone, at the beginning of their SQL career, get’s told that it is important to include an ORDER BY if...

Backup and Restore Automation using SQLCMD and SQL Server agent

Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...

Getting value out of data quickly

There are times when you need to create a “quick and dirty” solution to build a report.  This blog will...

Getting value out of data quickly

There are times when you need to create a “quick and dirty” solution to build a report.  This blog will...

Dates and Times in SQL Server: the problem with DATETIME

Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed...

Importance of Statistics

Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...