sqlsaturday.com
SQLSaturday #252 - Christchurch, NZ 2013 > Event Home
http://www.sqlsaturday.com/252
SQLSaturday is a free training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held on Aug 10 2013. At Christchurch Polytechnic Institute of Technology (CPIT), Madras Street, Christchurch, 8011, New Zealand. Welcome to SQLSaturday #252. SQL Saturday #252 - Keynote and Introduction. Building to scale: Overcoming Performance Hurdles. 10 easy ways to improve data quality. Microsoft SQL Server Project Hekaton. Using Event Notifications with SQL Server.
gumption.co.nz
Development | It Depends
http://gumption.co.nz/category/development
Development – It Depends. A Merry Christmas to the Nephews. December 27, 2013. Following on from the Birthday Present I made my daughters, I promised my sister some games for her boys Christmas presents. December turned into a pretty crazy month, but I got the last one finished on Christmas eve. Read More →. A Happy Birthday to My Daughters. August 24, 2013. Read More →. SQL Sentry Plan Explorer. Alan Featherston(TradeMe) On Online OLTP. Schedulers Unexpectedly Offline in Enterprise Edition of SQL 2012.
markread.net
Resources – Mark Read
http://markread.net/resources
Ramblings of a sql solution architect. A list of resources I trust you’ll find handy at some point … plus some light hearted SQL comedic relief. SQL Server History (Wiki). Microsoft SQL Server Home Page. Volume License Service Center (VLSC). Microsoft SQL Server Support Lifecycle. SQL Build and Patch Releases. SQL Max Capacity Spec. Microsoft Power BI Home Page. Microsoft Power BI Community. Microsoft’s Power BI Youtube Channel. MSDN SQL Server Community Forum. SQL Server Customer Advisory Team.
gumption.co.nz
It Depends | Rob's blog | Page 3
http://gumption.co.nz/page/3
It Depends – Page 3 – Rob's blog. TSQL to get last good DBCC CHECKDB. December 22, 2014. This is a piece of code I use to determine the last known good DBCC CHECKDB being run against a database. I’m surprised this information is so tricky to find. I’d expect it to be sitting on the database properties tab right under last known full backup. but it’s not. Instead it is listed as a database Info property, and we need to jump through some hoops to find it. Read More →. October 9, 2014. Read More →. Option N...
gumption.co.nz
September | 2014 | It Depends
http://gumption.co.nz/2014/09
September 2014 – It Depends. Archive for September, 2014. Stupid SQL Things To Do: Backup to NUL. September 30, 2014. Occasionally I’ve come across a site where backups are taken to disk = ‘NUL’. Note that’s NUL with 1 L and not NULL with 2 L’s. I’ve seen it recommended in a few places online as a quick fix where a log file has grown out of control and at least one SQL backup utility actively uses it under the guide of ‘truncating the transaction log’. Read More →. September 18, 2014. Read More →.
gumption.co.nz
Optober – SQL sp_configure Options – Priority Boost | It Depends
http://gumption.co.nz/2014/10/optober-sql-sp_configure-options-priority-boost
Optober – SQL sp configure Options – Priority Boost – It Depends. Optober – SQL sp configure Options – Priority Boost. October 9, 2014. Danger – Only enable this setting if you like running with scissors. Sp configure ‘priority boost’, 1. Just like the name says, this option boosts priority of the SQL Server processes. Which sounds like a good idea, but what does it actually mean? When should I use it:. What else should you know:. There is some light. This configuration is on the chopping block and w...
gumption.co.nz
SQL Community | It Depends
http://gumption.co.nz/category/sql/sql-community
SQL Community – It Depends. October 3, 2016. SQL Saturday Auckland is on October 15th and is being hosted in the Microsoft Office in the Auckland Viaduct. I’m fortunate enough to have been selected as a speaker which will mean dusting off my HA and DR talk which I last presented back at the start of the year in SQL Saturday Sydney. Read More →. SQL Sentry Plan Explorer. September 12, 2016. Read More →. Alan Featherston(TradeMe) On Online OLTP. August 9, 2016. Read More →. SQL Saturday South Island. And s...
gumption.co.nz
October | 2014 | It Depends
http://gumption.co.nz/2014/10
October 2014 – It Depends. Archive for October, 2014. Optober – SQL sp configure Options – Priority Boost. October 9, 2014. Optober rocks on today with a quick post on Priority Boost. I hadn’t planned to deal with this one until much later in the piece, but I’ve been reviewing a very unstable server for a client today, and it tracks back to this option. It’s another one of those things like ‘autoshrink’ which sound like […]. Read More →. Optober SQL sp configure options Optimise for Adhoc Workloads.
gumption.co.nz
It Depends | Rob's blog | Page 2
http://gumption.co.nz/page/2
It Depends – Page 2 – Rob's blog. February 10, 2016. So you are in Melbourne on Feb 20th and have nothing to do. What are your options? How about going to SQL SATURDAY! Http:/ www.sqlsaturday.com/464/eventhome.aspx I’m doing a session on how to index for optimal performance. Indexing is one of the magic switches in SQL Server that is often misunderstood and can make the difference in […]. Read More →. Nelson SSUG – John Martin on Securing your data. February 1, 2016. Read More →. January 28, 2016. Object...
gumption.co.nz
It’s a Corrupt World | It Depends
http://gumption.co.nz/2015/01/its-a-corrupt-world
It’s a Corrupt World – It Depends. It’s a Corrupt World. January 19, 2015. 1 Don’t try and get the application online as quickly as possible. Unfortunately this particular application support person undid all his good work by following up with advice to the client to turn off checksum on all databases, a piece of advise akin to saying we can reduce the number of people convicted of murder by making murder legal. 4 Now you have defined the problem, and the required fix, go ahead and fix it.