Latest Blog Posts
I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific connections and the MiFi and cellphone uplinks I spotted this one:
That just screams, “No!” TANSTAAFL.
In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual. While it might not be the most practical visualization it does provide a fun way to show categorical data and can have multiple series shown as well.
Module 02 – Enlighten Aquarium
There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near Liverpool Stree and the Moorgate stations.
And I want to go.
I can’t. I’m a bit traveled out, my family is a bit tired of travel overall, and I need… Read more
3 comments, 1,435 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 6 June 2016
Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
Can we have more than one version of Powershell?
Yes, You can have multiple versions PowerShell.
How to switch between Powershell version?
ps:\>Powershell -version 4
ps:\>Powershell -version 3
ps:\>Powershell… Read more
This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.
Here is a link to the YouTube Video of the presentation.
Check at the bottom of this blog post for a zip file containing the PPT as well as… Read more
If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend! We have a fantastic weekend planned:
- On Saturday, June 11, we have our free conference, with around 30 sessions on all aspects of SQL Server, plus a Women in Technology…
It’s Monday time for this week’s Monday Morning SQL Break. A chance to catch up on links I’ve shared and popular post from this blog. To keep the conversation going through the week, follow me on twitter (@StrateSQL).
To kick things off this week, it’s Monday so let’s… Read more
The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve been involved in looking at some early designs and functionality, and have been waiting for the product to get to the point I could play with it more.
Be sure… Read more
MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the bulk of my writing these days, mainly because I like the problem/solution format. However, the folks at MSSQLTips didn’t just write to acknowledge their 10th birthday.
They also posted… Read more
The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to create views that join across databases. Since I haven’t tested this myself, and I haven’t seen anyone else doing anything with it yet, I decided to set up a test.… Read more
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I think I was able to name 3. Ever since then I’ve paid particular attention to DBCC commands in preparation of the day when I hear that question again. Well not… Read more
In the previous article in this blog series I told you my plans of expending my horizons towards the Data Science field. As I noted in that article my first steps towards Data Science consists of getting my math knowledge up-to-date again on math areas like linear algebra and matrices. Read more
Well most of the SQL Server news last week focused around the launch of SQL Server 2016. SQL Server RTM dropped on 1st June and a quick twitter poll, suggests that some people at least will be deploying SQL Server 2016 in production before the end of the year.
Free indexing books, awesome!
Before I tell you how, lets start with what we are talking about here. If you weren’t aware, last summer I worked with Grant Fritchey (Blog | @gfritchey) to update Expert Performance Indexing for SQL Server. The new edition jumps from 10 to… Read more
I’m going to be speaking for the downtown Chicago SQL Servers User Group at 5:30pm on June 9th! I plan to start the session with my constantly evolving session – Virtual SQL Servers. Actual Performance. – and moving into more of a round-table format, where all of your questions… Read more
I was writing a poorly performing UDF the other day and then wanted to replace it with a better performing one. However, I wanted to be sure that the function was the acting the same externally. In other words, does all my code that calls the function work the same? Read more