Latest Blog Posts
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
Actually, Maryland, but close enough. I’ll be in Chevy Chase this weekend, first for our SQL in the City Seminar on Deployment Friday, and then SQL Saturday #233 on Saturday. Both events are free, so if you can come to one or both this weekend, register and come. The registration… Read more
December 11: Holiday Party at On the Border - free for user group attendees, door prizes from sponsors! http://www.brssug.org/group-news/december13batonrougeusergroupsholidayparty
January 8 '14: Two…
A couple of weeks ago I did two webinars for the Pragmatic Works Free Training on The T’s. The first was a session on how to load a data warehouse with SSIS. The followup session was about getting started with SQL Server Analysis Services (SSAS). You can find the link… Read more
I’m not going to sugar coat it. I’ve been a bit of a slacker lately. Unfortunately I didn’t get the Q&A for my two webinars up the week I did the presentations. So here is part 1 and the SSAS post will be separate. To start with, thank you for… Read more
It started like any other Monday following a long holiday weekend. Hundreds of emails to filter through, a new client launch (after a holiday weekend? Really?), and a pager that somehow survived the weekend without being tossed into a lake. It ended with one of my heroes buying me a… Read more
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. While these links aren’t the answer to life, the universe, and everything, they do share a few… Read more
Run this code:
CREATE DATABASE MyRestoreTest ; GO USE MyRestoreTest go BACKUP DATABASE MyRestoreTest TO DISK ='myrestoretest.bak';…
The holidays are upon us and it’s the first Monday in December. That means it’s time once again to take a look at your SQL Server environment and verify that things are where you want it to be. And where you need it to be. The aim is… Read more
A quick check of my calendar this morning reminded me that I am presenting a session for the PASS Performance Virtual Chapter this week. It’s completely free, you just need to be a member of PASS in order to register.
Not a member of PASS or unsure what it offers… Read more
Well the short answer is that they just don’t have enough information to give a definitive answer. You will notice that “it depends” is almost always followed by a series of questions. This is very similar to the Chaos theory that as I understand it basically says that if you… Read more
I had the privilege last week of talking with Richard Campbell (t), Microsoft MVP and host of the very popular RunAsRadio podcast, a sister-show to the worldwide phenomena known as .NET Rocks!. Here’s the write-up Richard used to describe the show:
Richard talks to Kevin Kline about… Read more