magicpass.sqlpass.org
Free Tools
http://magicpass.sqlpass.org/FreeTools.aspx
Red Gate SQL Search. Enterprise Policy Management Framework. Ola Hallengren's Maintenance Solution. SQL Server Management Studio. Glenn Berry's SQL Server Diagnostic Information Queries. SQL Sentry Plan Explorer. Free SQL Server Tools. At our monthly meetings we regularly feature free SQL Server tools to make your job as a database professional easier. Here's the full list:. Fully automated reindexing solution that's intuitive to use, simple to customize, deeply configurable, and easy to report from.
davidwimbush.wordpress.com
In praise of StatisticsParser.com | David Wimbush
https://davidwimbush.wordpress.com/2016/01/22/in-praise-of-statisticsparser-com
Observations of a SQL Server DBA. In praise of StatisticsParser.com. Here’s a great free addition to your query tuning toolbox that you may well not have heard about: StatisticsParser.com. It hasn’t been mentioned nearly enough in my opinion. Here’s how the author, Richie Rump, puts it:. Here’s a quick look at what it does. If you want to see how long each part of a query takes or what logical reads are involved you can set a couple of options on: statistics io and statistics time. Thank you, Richie.
jorriss.net
Projects
http://www.jorriss.net/projects
Random Thoughts of Jorriss. Richie Rump on the merging of code and data. I really like building things. Below you’ll find some of the projects I’m involved with. Most of these are tools that I use that help me diagnose issues but others I do just for fun. Visit StatisticsParser on GitHub. More info about sp DataProfile. SQL Server Data Dictionary. Visit SQL Server Data Dictionary on GitHub. Download Sql Server Server Data Dictionary.zip file. This is fantastic demo data. This is where SODDI comes in&...
sqlstudies.com
Free Scripts | SQL Studies
https://sqlstudies.com/free-scripts
Skip to main content. Skip to secondary content. Live, Learn, Share. Study and Reference Materials. Here is a list of some of the most popular (and useful) free scripts and queries I’ve seen around the interweb. There are lot’s more and I’ll be adding them as I’m reminded of them. These guys seem to be putting out a script a week these days but they are still some of the highest quality and amazingly useful. They are now open sourced. A general health check of your instance. Troubleshoot your slow server.
sqlsvrdba.com
Statistics Parser – SQL Server Blog
http://www.sqlsvrdba.com/statistics-parser
Skip to main content. February 20, 2015. Want to make very quick sense of the output from STATISTICS IO and STATISTICS TIME, well, read on. I found a really cool online tool which parses this information and presents it in a nice tabular form. Check out Statistics Parser. I’ll give you a quick example. I’m using AdventureWorks2008R2 and put together a very crude query (apologies! Name, c. AccountNumber. When the query completes, look at the Messages tab in SSMS. SQL Server parse and compile time:. Table ...
myhumblesqltips.blogspot.com
My Humble SQL Tips: Tracking Query Plan Changes
http://myhumblesqltips.blogspot.com/2015/04/tracking-query-plan-changes.html
My Humble SQL Tips. I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server. Thursday, 30 April 2015. Tracking Query Plan Changes. I was reading a blog post from Brent Ozar ( SQL Server Query Store. I was inspired by a comment under the post that suggested one could set up such a store of his/her own. Aha, I thought! Now, you might ask, why would I want to do this if Microsoft has plans to release it. Well, for a few reasons: 1. They haven...Step ...
myhumblesqltips.blogspot.com
My Humble SQL Tips: Tracking Page Splits
http://myhumblesqltips.blogspot.com/2015/04/tracking-page-splits.html
My Humble SQL Tips. I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server. Friday, 17 April 2015. First off, if you want some good information on these concepts read the following articles:. Fill Factor Intro by Kendra Little. Tracking Page Splits with Extended Events. The implementation of my solution involves the following:. Extended events that track page splits based on the second post above. They track two things. An SSIS package that:.
myhumblesqltips.blogspot.com
My Humble SQL Tips: July 2015
http://myhumblesqltips.blogspot.com/2015_07_01_archive.html
My Humble SQL Tips. I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server. Friday, 24 July 2015. This post aims to aggregate a lot of the best practice or otherwise recommended configuration for SQL Server performance. It is meant as a summary or quick-reference sheet. All of these concepts are discussed at length all over the internet, so I will not spend much time explaining them. . 160; What this post should . Friday, July 24, 2015. I ran int...
myhumblesqltips.blogspot.com
My Humble SQL Tips: Running DBCC CHECKDB on TEMPDB
http://myhumblesqltips.blogspot.com/2015/04/running-dbcc-checkdb-on-tempdb.html
My Humble SQL Tips. I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server. Thursday, 9 April 2015. Running DBCC CHECKDB on TEMPDB. First, a confession. I've been doing it wrong for a long time. Only recently have I learned that TempDB should be included in regular CHECKDB maintenance. Ok, now that I've got that off my chest, I can continue. I wrote a loop that runs until there are no exclusive locks within TempDB. I put in a delay so that th...
myhumblesqltips.blogspot.com
My Humble SQL Tips: May 2015
http://myhumblesqltips.blogspot.com/2015_05_01_archive.html
My Humble SQL Tips. I'm keeping this blog as a repository for SQL tips and tricks I have learned over my time working with SQL Server. Tuesday, 26 May 2015. Add an Operator to All SQL Server Agent Alerts. Tuesday, May 26, 2015. Links to this post. Tuesday, 19 May 2015. Study Materials for MCSE Microsoft Exams 70-457, 70-458, 70-459. I passed the 70-457! Now studying for 70-458. I passed the 70-458! Now studying for 70-459, booked for Jan 29, 2016. I am studying for the MCSE Certification and will be taki...
SOCIAL ENGAGEMENT