Archives: November 2016
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB whereas Data file is only 1GB for MSDB on server.
Findings: We found system owned open transaction in MSDB which is causing issue.
Transaction information for database ‘msdb’.
Oldest active… Read more
Awhile back I was working in SSMS and saw this window.
It threw me off since I was trying to write some code and hadn’t expected it. I clicked Escape, Enter, a few things and was getting frustrated when it disappeared.
I ignored it until I saw the window again… Read more
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we discuss hacking your own professional development.
Having a plan for your professional development is essential when tackling your career goals. You need to have… Read more
I was recently asked to help tune a stored procedure that has been historically taking between 55 and 60 seconds to complete. Overall the code wasn’t too complex but getting to the root cause did surprise me a bit.
We run a mixture of SQL Server 2008 R2 and SQL… Read more
It’s hard to believe it’s been more than 10 years since we started the planning for the first event in Orlando. The success of the idea seems obvious now – surely the time was right for something to happen in our space. Back then though it was far from obvious.… Read more
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a clause that lets you output the changed data from an INSERT, UPDATE, DELETE, or MERGE statement. One of the comments on the article was a question… Read more
This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing that custom image up to the Docker repository.
Let’s quickly check that we have our custom image, so run (in an admin powershell session):-
Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1 which besides bug-fixes and small improvements introduces support for Columnstore Indexes on any edition of SQL Server starting with SQL Server 2016 Service Pack 1 and the initial bits for… Read more
One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday is worth watching. I also struggle writing abstracts and attracting people to my own sessions, so I think the idea of GroupBy allowing rating and reviewing of abstracts in advance… Read more
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL… Read more
In this module you will learn how to use the Synoptic Panel Power BI Custom Visual. The Synoptic Panel is really one of the more impressive visuals available. This visual allows you to take an image and plot data on different regions that you define.
Module 27 – Synoptic Panel
Concurrent with SQLSaturday Orlando we ran our third student seminar. This is our way of giving back to the college that so kindly gives us free space for the event and of encouraging students to see IT as a great career choice.
- Attendance was down last year, not good. This…
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup and Minion Reindex...and it's coming in early 2017.
The basis of all the DLM Automation from Redgate is a series of PowerShell cmdlets. They might look intimidating or confusing, but they aren’t. This is part of a series of posts that examine how you use each one.
Previously I looked at New-DatabaseConnection. In this post, I’ll go through… Read more
There are a bunch of ways you could create a database clone. Backup and restore is one method. Export/Import is another. There are even third party tools that will help with that. However, each of these has a problem. It’s moving all the data, not just once, but twice. You… Read more
This year we held our 10th SQLSaturday, a very nice milestone to hit. I’ll reflect in a separate post on the growth and future of the overall franchise – there’s a lot to think about – but I’ll mostly keep this post specific to the event itself.
This turned out… Read more
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC CHECKDB in most if not all of those lists. Unfortunately, the output can be long, overwhelming and a more than a bit difficult to read. So here are a few… Read more
There are several ways to execute SSIS packages that have been deployed to the SSIS catalog, and my favorite way of performing this task is to execute SSIS packages with T-SQL. There are a couple of challenges that come up when executing catalog-deployed packages using the default settings in T-SQL,… Read more