Latest Blog Posts
I can’t believe it’s almost time for SQL Saturday #610. I’ll be there presenting What is Power BI? If you are in the Richmond area Saturday, March 18, 2017, please stop by and say “Hello”, I’d love to see you. There are tons of other sessions as well, so… Read more
I think it was 2003 or 2004 when someone from PASS came to Orlando and helped start what became OPASS. They stressed the need to find speakers each month and the need to have multiple people involved so that the group wouldn’t die if someone moved on. The formula was… Read more
Scenario: Dump Excel File Contents to a Table in SQL Azure
Develop SSIS Package-
- Drag Data Flow Task on the control flow window and double…
I showed in my previous post how we generated the datasets for our Azure Data Factory pipelines. In this post, I’ll show the BimlScript for our pipelines. Pipelines define the activities, identify the input and output datasets for those activities, and set an execution schedule. We were creating several pipelines… Read more
I did it! I did my first “real world” presentation this morning at the Triad Developers Conference in Winston-Salem. What I mean by “real world” is not a PASS audience. These were total strangers off the street that I didn’t know, well, there were some familiar faces and even a… Read more
This post is about a reporting services configuration issue that you will face after changing the database server name. I’ve blogged about Changing SQL Server name and warned on issues with SSRS.
After making a change of the server name, a period later when I run my Report manager I… Read more
Just over a week to go until SQL Saturday Iceland! Really looking forward to presenting my session and then I have four days to explore!
Building the Terminator Vision HUD in HoloLens
Because why not?
These days I do a lot of testing with SQL Server. When I am testing new features or helping clients implement SQL Server High Availability solutions I want to have several tests including blue screens.
Simulating blue screens actually might be much easier than you think. For example, you can… Read more
I’ve been working with running SQLSaturdays in the Richmond, VA area for several years now. It seems that every year, I end up blogging something new. Frequently, this ends up being a script of some kind to help me out. This post follows this theme by introducing a… Read more
· sys.dm_db_missing_index_details– Detailed specifics on the missing indexes, including column lists· sys.dm_db_missing_index_groups– relates individual missing indexes to index groups
· sys.dm_db_missing_index_group_stats– information on potential…
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of data is an important part of any data initiative, especially in the data warehousing space. While data quality does get its share of attention, there is a concept that is… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
In my last post, I talked about what a DACPAC was. Now let’s create one. This turns out to be about as simple as it could be.… Read more
While you may not need to worry about the physical location of a row very often, every so often the need comes up. In a few of my earlier posts (here), I have needed this information to prove a point. This post shows how to identify a row’s… Read more
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new features in the Azure first, then at regular intervals (the releases) those changes get pushed to on-premises versions of the applications. Our version means, in any new development check… Read more
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some help troubleshooting a SQL connection issue. He had an application server that could not connect to one of our SQL Servers.
We have a fairly complex and secure network environment.… Read more
I’ve already covered how to push images to the Docker hub here but what if we only want to share a custom image in-house?
What I’ve done is created a custom… Read more
By Steve Bolton
…………Imagine how empowering it would be to quantify what you don’t know. Even an inaccurate measure might be helpful in making better decisions in any area of life, but particularly in the business world, where change is the only certainty. This is where a program of… Read more
What is this?
Well if you read the name aloud "SQL Server Continuous Deployment in a box" then, if I have done my work correctly choosing the title for the blog, give a hint :)
what is the big idea?
There is really some great tooling for SQL Server -…