Looking at wait stats differently with SQL 2016
Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on sys.dm_os_wait_stats...
2017-01-16
625 reads
Arun Sirpal
Checking Time Zones in SQL Server
I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself...
2017-01-13
1,320 reads
I used to shrink my databases!
This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger”...
2017-01-11
811 reads
SQL Server Bugs & Enhancement Requests
T-SQL Tuesday #86: SQL Server Bugs & Enhancement Requests hosted by Brent Ozar. https://www.brentozar.com/archive/2017/01/announcing-t-sql-tuesday-87-sql-server-bugs-enhancement-requests/ I did not want to miss out...
2017-01-10
623 reads
Clearing Plan Cache in SQL Database (Azure)
Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot...
2017-01-05
620 reads
Checking DBCC CHECKDB
I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to....
2017-01-03
577 reads
TDE Recovery
This week’s TSQL Tuesday is being held by the mighty Kenneth Fisher – Backup and Recovery- see this link, how can...
2016-12-26 (first published: 2016-12-07)
1,496 reads
Why I am called BlobEater
It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...
2016-12-17
517 reads
Locking Resources in Azure
I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...
2016-12-16
519 reads
CHECKDB and Page Restoring from SSMS
Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...
2016-12-15
464 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
WHERE condition using ='value' returns different results that using IN('value')
Have an interesting scenario - user found a discrepancy with rows returned when running...
Complex Query (Multiple Tables & Joins) - Need to Restrict to Max Date
I am using the query listed below. USE GAGETRAK_26237 SELECT G.Gage_ID 'ID', G.Model_No 'Model',...
Unknown Token Received From SQL Server
I have an issue when a stored procedure is executed from the SQL Server...