Latest Blog Posts
When working with a MySQL database as a source you may experience some unexpected results in your data extracts. Most of the issues are related with handling of certain data types such as “TinyInt”.
A particular issue I recently came upon was the fact that TinyInt(1) is treated by default… Read more
This is the second in a series of articles about creating a simulated environment for testing systems that cross subnets.
- Part 1: Networking
- Part 2: Domain Controller
Lookup is one of many transformations available in SQL Server Integration Services (SSIS). Its purpose is to perform a JOIN of two datasets: input columns from a data source and columns in a reference dataset – a table, view or a result of a query. Lookup can be used in… Read more
When restoring a database that doesn't exist, say for instance when a client sends a database to you, you can't use the option to restore database, because there is no database matching to restore. To get around this you need to use the Restore Files and Filegroups option and then… Read more
System: 5.5GB of RAM, Windows 2008 R2, vmware, 4 cores, SQL Server 2012 Standard Edition. The database currently has the following data files: two files in the PRIMARY filegroup, and one other file in another filegroup, plus one log file. It used to have two log files…
Current… Read more
So here we are at week 4 of the #SQLNewBlogger challenge. Earlier in the week I responded to the following post on Twitter #sqlhelp, and after I posted my response I thought that this would make a fun blog post. I have used PowerShell to export SQL Server tables to… Read more
Amongst IT related problems one that can fill this most ardent optimist with dread is when logging into your pc you get the message that you have been logged in with a temporary profile.
Well that was what happened to me Friday evening. My heart sank. Have I lost all…
In this post we are going to show the implementation of a PowerShell script using SMO to move data between filegroups on SQL Server. This article is the second of our two part series on “Moving SQL Server data between filegroups – Database Structures”, you can find the first article… Read more
When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way.
The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…
BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want to go over another new feature of In-Memory OLTP, natively compiled stored procedures. Natively compiled stored procedures differ from normal stored procedures in that the In-Memory OLTP… Read more
If you’re reading this, we have done business together, either directly or indirectly. You might be a retail website from which I purchase products or services. You could be a social media empire on which I share blog posts, life events, and… Read more
It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me… Read more
Last month I participated in Ed Leighton-Dick’s April Challenge. My four posts were tagged the April Challenge, and this month I plan to continue, and hopefully get a few more people to up their blogging.
Building on April
To make the next step in starting to blog regularly,… Read more
It’s been a while since I’ve posted a blog post. After the new year, I had been trying to decide on a better way to share the Monday and Friday blog posts that I’ve done for the last couple of years. Of course, analysis paralysis and my lacking php skills… Read more
I have two exciting SQL Saturday preconference training sessions coming up in the month of May!
The first is my Virtualization for SQL Server Professionals training session at SQL Saturday Rochester NY on Friday, May 15th.
Session Abstract: Microsoft MVP and VMware vExpert David Klee leads this full-day introduction… Read more
Let me start with an important note: I am voicing my opinion here as an individual, not an… Read more