Somewhere to put that data while your script runs

Ever writing a script and want to quickly place some data in a file while in the middle of your process? Try out [System.Io.Path]::GetTempFileName(). This method gives you a file with a random, unused file name in your local temp folder where you can write out interim information without worrying about testing whether the file…


How to find out what you need to know

For as long as I can remember I have come across problems where I need to know the range of valid options for a setting so that I can make an appropriate change, but I haven’t know the right values to use. For  example – If you wanted  to change the powerplan of your computer…


Fill Factor and Data Compression

Another post by our excellent US PFE Susan Van Eyck goes though Fill Factor and Data Compression!   I got a pair of interesting questions from a colleague this week: If you’re using fill factor then enable data compression, is the fill factor still enforced? If you aren’t using fill factor and enable data compression…

2

Microseconds Or Milliseconds

  While working with a customer on creating some Extended Event to collect performance trace, I was if asked if the duration is in microseconds or milliseconds. Thinking to myself, “well in SQL 2005 and later it is in microseconds”, although the Profiler UI has an option to display the value in either milliseconds or microseconds. …

0

You really need to look out for msdb security

So msdb, we don’t really think about it that much right? We know it holds the metadata for our Jobs and Schedules, also some good info on page corruptions, as well as backups, and much more. But how often do we think about it’s security? You may already know that the Guest user is enabled…


Troubleshooting Using Ring Buffers

Working at a customer site, and I happened to notice that the Exception ring buffer contained a lot (and I mean A.L.O.T.) of errors. Ring Buffers were introduced in SQL 2008, and contain a fixed size cycle of records for the ring buffer they pertain to. Now… note – sys.dm_os_ring_buffers is a DMV which is…


Advantages and Annoyances of Filtered Indexes

This weeks great post by our US Senior PFE Susan Van Eyck talks about the wonders of filtered indexes! Check it out!   Today’s Byte is about the advantages and annoyances of filtered indexes.  We’ll talk about What they are Where (and why) they’re useful How to create one How to convince the optimizer to…

0

Instant File Initialization–Do You Know It’s Value?

This weeks post by our US Senior PFE Susan Van Eyck is about the value of using Instant File Initialization. Lets have a look!   Be convinced of it’s value! This week’s Byte is about something the SQL Server world refers to as “Instant File Initialization” or IFI.  Interestingly, it’s not really a SQL Server…

0

Install SQL Server Books Online – Offline

Many of my customers run production environments which have never, and will never, be able to connect directly to the internet. They still have the desire to install Books Online (BOL) into those environments though, which leads up to this blog post – how do we do that? SQL 2012 & SQL 2014 For SQL…