Latest Blog Posts
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables for differences and generate a T-SQL script to synchronize them. It's a rudimentary but useful tool that most people don't know is available and it gets the job done when… Read more
Today I have uploaded the 8th SQL Server Quickie to YouTube. This time I’m talking about Hash Indexes in SQL Server 2014. You can find the script used during the demonstration here as a download.
Thanks for watching!
As I mentioned in my previous post (see Power BI first impressions), Power Query is a great new tool and Microsoft has been updating it frequently. The latest update has many new features, among them:
- Connectivity to Windows Azure Table Storage – You can now import from Windows Azure…
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m going to discuss are:
- About the goals you should set for your first week on a new job as a DBA
- Why backups & free space are the most…
Come get your learn on with Pragmatic Works and myself! In January I’ll be dropping some knowledge about change data capture and how to consume it with SSIS. CDC is one of the features I wish more of my clients were leveraging. It makes doing incremental loads dramatically more simplified.… Read more
First, what's blocking?
0 comments, 56 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 5 December 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations,… Read more
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let… Read more
A while back I talked about the DEFAULT keyword and using it to tell SQL to use the default value without having to specify an actual value. Well along that same note, what do you do if you want all of the columns to use their defaults? Or if you… Read more
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend so bring a co-worker…or two. These events provide for great learning opportunities, as well as networking with other local SQL Server professionals. Some groups are not holding a regular… Read more
I got a request to monitor multiple services and send an email to intended recipients. This post explains how to monitor a multiple services on a group of servers. The function Get-ServiceStatusReport comprises of various cmdLets and function to monitor services on a list of servers.
- HTML Ouptut
Digging Around In Google Code
Google Code was very thin when it comes to SQL Server. I did find a few of interesting projects that may appeal to others as well as me. I will say there was a TON of use SQL Server with x programming language.
Microsoft publishes the following caution about enabling the CredSSP Windows Group Policy:
Caution: Credential Security Support Provider (CredSSP) authentication, in which the user’s credentials are passed to a remote computer to be authenticated, is designed for commands that require authentication on more than one resource, such as accessing a remote… Read more
Ok, so it’s not quite the end of the year yet. I figured I would get a head start on things. Who says that this type of post has to come on January 1st though? Well here goes. Let’s talk a little bit about what has happened in the last… Read more
So last Monday I announced a giveaway that I think is a great gift to give away. Every Monday for the rest of this month prior to Christmas, I'm giving away a 1 Month Plural Sight code.
Congratulations Daniel U! You win the month code. I will E-Mail…
- The Time Series algorithm has several parameters that may be adjusted if needed. I have tried adjusting several of these parameter settings and determined that the following appear to have the most impact:
- MISSING_VALUE_SUBSTITUTION: If you have any blanks or gaps in your data and the MISSING_VALUE_SUBSTITUTION parameter is…
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. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not forget what… Read more
“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have a video at Power BI for Office 365 video). Each of these products have different requirements:
This tool helps you get the disk space information on the computers of your choice. Either you can type the path of an input file or hit ‘Browse Button’ to select the file using dialog option.
Put the select input file and hit ‘GetDisk’. It will query the disk space… Read more