Latest Blog Posts
With SSIS 2014 and earlier there is currently not native way to refresh an Excel workbook which include Power Query queries. Now that functionality is rumored to be included with SQL Server 2016 but if you’re currently running SQL Server 2014 or 2012 you are out of luck. But that’s… Read more
T-SQL Tuesday is a monthly blog party where we get an invitation the first week of the month to write on a specific topic for the second Tuesday of that month. Adam Machanic came up with the idea and he chooses the hosts.
If you’re interested in hosting, contact him. Read more
tbl.name as [Table Name]
, trig.name as [Trigger Name]
FROM [sys].[triggers] as trig
INNER JOIN sys.tables as…
As data professionals, there are times when our jobs are relatively easy. Back up the databases. Create the dashboard report. Move the data from flat files to the database. Create documentation. There are lots of cogs… Read more
CREATE TABLE dbo.Disk_tbl
[ID] Int identity(1,1) Not null PRIMARY KEY CLUSTERED,
I was actually travelling for most of July and some of that was on holiday with the family, the real family. That’s why I didn’t get a June update posted.
I don’t have anything much exciting to report. We’re finally getting data out of our Chapter database and can report… Read more
I built a brand new virtual machine running Windows 2012 R2 and SQL Server 2016 CTP 2.2 (the June edition). The exact version as shown in the error is 13.0.0407.1 but in SSMS it returns 13.0.407.1. As some of you may know, one of the new things in SQL 2016… Read more
I ran into an issue with errors with an database upgrade running into a violation of a foreign key constraint. Don’t know how it happened. Figured that while I’m at it, I’d go ahead and evaluate every single check constraint in the database to see if I could identify any… Read more
Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to adopt BI technology need not look further. Power BI is easy to learn with its intuitive tools. Gone are the days when building BI solutions always involve massive… Read more
In the world of performance monitoring, there a number of ways to identify problems. Each method is different and usually, neither way is better than another.
Over the years, I’ve started look at metrics around non-clustered indexes to help find problems. Once while working at a client site, I was… Read more
Whoa whoah. Aren’t you supposed to increase your data flow buffer size in order to speed up your packages? If you have enough memory and you can process more rows at the same time because your buffer is larger, that’s what we want, right? Yes, this is confirmed by the… Read more
Earlier today I was working on a project where I was recording some time stamps. In order to get as much precision as possible I decided to go with a datetime2 datatype. Unfortunately when I recorded the time stamp it didn’t quite work out liked I’d hoped.
DECLARE @StartDate datetime2…
3) If a clustered index…
This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach of string concatenation.
This seems very easy but we need to cast the parameters in VARCHAR and sometimes we stuck in single code.
I am sure this happened with all… Read more
David Pless is presenting:
Query Store is a new feature in SQL Server 2016, and is also available in Azure SQL Database V12. Query Store is designed to help with query performance troubleshooting by making it easier to identify poorly performing statements and finding scenarios where performance regresses. In this… Read more
The Office 2016 Public Preview is now available for download! Included in the preview of Excel 2016 are a handful of new chart types and since I’m a huge fan of awesome data visualizations, I thought I’d take a few moments to play around with them and share my… Read more
In my Introduction to Hadoop I talked about the basics of Hadoop. In this post, I wanted to cover some of the more common Hadoop technologies and tools and show how they work together, in addition to showing how they work well with Microsoft technologies and tools. So you don’t… Read more