Latest Blog Posts
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
Added few more examples
Originally posted on Prashanth Jayaram :
On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance. There are many ways to get the result. This post gives you an idea and SQL in which…
Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list. If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement.
What Does It…
I found another use for Powershell, one actually suggested by someone else: attaching specific SQL Server databases.
TL;DR I have a script that detaches all user databases from a SQL Server instance and then reattches certain ones. Full script at the end.
We have a lot of demo… Read more
Great Articles at SQLPerformance.com
There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space.
So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back:
Back in October 2014 Midnight SQL released v1.0 of Minion Reindex, a free, open source index maintenance solution. I’m all for making my day job easier so I once I heard about this I wanted to get it into a development environment asap to see what it can do. Unfortunately… Read more
The PASS SQL Saturday events are meant to be a place to grow the pool of speakers, provide a mechanism for the speakers to learn, and fulfill the PASS goals of Connect, Share and Learn. So, you’ve decided you want to start speaking at a SQL Saturday event. Cool. You… Read more
Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly regular basis. What I don’t think a lot of people know is that there are two types of temporary tables.
- Local Temporary Tables
SELECT * INTO #LocalTempTable FROM sys.databases
Wrangling large or complex Excel workbooks in SSIS can be a challenge. From managing data types (more about that in this post by Koen Verbeeck) to addressing multiple worksheets in a single document, configuring SSIS to properly read from or write to Excel documents is tedious at best. While there… Read more
When you work in a offshore - onsite setup in IT industry and if you are fortunate :-) to be a part of the offshore team then there are many compromises that you have to make. Out of those one such is to develop your code based on…
Replace the Data Source and Initial Catalog values of WebConfig.XML
Content of XML file
<Configuration ConfiguredType=”Property” Path=”\Package.Connections[ConnStaging].Properties[ConnectionString]” ValueType=”String”>
<ConfiguredValue>Data Source=localhost;Initial Catalog=Stage;Integrated Security=SSPI; Connection Timeout = 10</ConfiguredValue>
PARAM( [String]$DatabaseName='DCTarget', [String]$XML='c:\webconfig.XML', [String]$DatabaseServer='
Call for speakers is now open for SQL Saturday #408 in Houston, TX. If you are interested in presenting please fill out the form – https://www.sqlsaturday.com/408/callforspeakers.aspx. The call for speakers ends on 4/14/2015.
For complete details on the event see – https://www.sqlsaturday.com/408/eventhome.aspx.
SQLSaturday is a training event for SQL… Read more
Like most people I have a bucket list of things to do before I depart for other things. However I chose to have two bucket lists, one personal and one professional. I’m now one step closer to ticking another one off of my professional bucket list, the title should give… Read more
It’s not a question of scheduling. I just haven’t been to lots of community events in the last several months so that I can see community speakers and find one to give an award to. I’ve been trying. So, we’re giving out two awards this month (my blog, my award,… Read more
I am pleased to announce a brand new pre-conference training session, entitled “SQL Server Virtualization for VM Admins“, to be launched on Friday, April 10th, the day before the upcoming SQL Saturday event in Madison, Wisconsin. The price is only $100 for the entire day of training! Read more
I was testing something the other day and realized this was a security area I didn’t completely understand. I decided to write a few posts to help me understand the issues.
I want to give a developer rights to create objects in a schema. In this case, I’ll stick with… Read more
A short piece, as I ran into the need recently to alter a column to NOT NULL status. I’ve rarely done this in the past, usually specifying NOT NULL when I create the table. Often in future changes, I’ve been wary of not allowing NULLs since I’ll always find an… Read more
This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012. So far, we’ve covered:
- Tables and Schemas in the data warehouse
- Dimensions and Slowly Changing Dimensions
- Fact tables and measures
The question came up at SQL Rally, “Can you use Extended Events to monitor for query timeouts?”
My immediate response was yes… and then I stood there trying to think of exactly how I’d do it. Nothing came quickly to mind. So, I promised to track down the answer… Read more