Latest Blog Posts
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing up some of my old posts to… Read more
I hope you were able to attend my free webinar on Creating Power Map Reporting Solutions on April 17 2014. If you weren’t you can now watch the recording here.
Following each webinar I like to post a quick Q&A session for everything I was not able to answer in the allotted… Read more
I made some small improvements to a few of the queries this month. I plan to add several more SQL Server 2014 specific queries over the next couple of months, along with a lot more comments on how to interpret the results of each query in the entire set.
I’m heading back to SQL Bits for the third time and I’m excited to be going again. I think that this is my favorite conference, hands down. The large mix of people, the incredibly welcoming hosts and the casual atmosphere make this one of the events I look forward to… Read more
Next month, I’ll be making a couple of stops at SQL Saturday events in the south. On May 3, I’ll be attending SQL Saturday #285 in Atlanta and presenting my SSIS Performance session. I’ll be traveling with my good friend and neighbor Ryan Adams, who is also presenting at… Read more
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.
Posts That Were Popular This Week
I recently came across the following error message when I tried to look at the batches in the Integration Management section of MDS:
515: A database error has occurred. Please contact your system administrator
Too bad I am the system administrator on that machine…
Anyway, after some searching it came… Read more
I hope you were able to attend my free webinar on Bringing Power BI Q&A to your Organization on April 15 2014. If you weren’t you can now watch the recording here.
Traditionally following a webinar I try to post a quick Q&A session for everything I was not able… Read more
Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW). It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW. That new feature is the ability to have a HDInsight region… Read more
By David Postlethwaite
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover.
SQL Server Management Studio will autosave your unsaved query every few minutes so if if your pc…
SQL Server 2014 is deeply integrated with
Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM is much easier and seamless now.
This post talks about the journey of a database named “MoveMeToCloud” which is hosted on SQLServer 2014 RTM on-prem instance to a SQL Instance… Read more
At my Filestream/Filetable talk yesterday at SQL Intersection, someone asked me about programmatically adding a file to a Filetable. Easy enough, I thought, since I’d seen someone do this in .NET and was thinking this has to be simple. Turns out it’s not quite so simple.
I was assuming that… Read more
Microsoft just announced a new mechanism for managing your Azure resources, Automation. You can check out the documentation on it here. It’s a mechanism to create runbooks using PowerShell that you can then combine with other runbooks inside a runbook, etc. Let’s check it out. I’m doing everything you… Read more
As of right now, my United account has no flights booked. My Hilton Honors account has no hotel rooms reserved. My National account has no car rentals to pick up.
For now. I suspect things will change soon, but… Read more
Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more
We can create a database simply by typing in the command
create database DB1
We don’t have to provide any other parameters for SSMS to be able to create the database
My Question is from where does SQL get the default values when we create a database without any options?
I wrote a guide about using Git and GitHub for "Windows people".
This is the guide I wish was available when I got started with Git last year.
The guide takes you through everything you need to know to get started with Git and GitHub, and only requires a Windows… Read more