Trust: A Business Essential

An unexpected conversation recently led to a concept that my mind kept going back to: business moves at the speed of trust. Turns out that’s not a very original idea—The Speed of Trust is the name of a book by Stephen M.R. Covey.

Regardless of who came up with the idea, trust is obviously essential in […]

By |December 11th, 2015|SQL Group|0 Comments

PowerShell: Another Reason to Continually Grow Your Skills?

“Major Changes Coming from Microsoft Will Impact Your Career.” That was the headline from an article we encountered on Facebook recently.

Turns out one of the changes makes PowerShell rather important: Windows Server 2016 Nano Server won’t support video connections or have a GUI. In the words of Don Jones, Pluralsight Curriculum Director, “It’s PowerShell or […]

By |November 17th, 2015|SQL Group|0 Comments

SQL Solutions Group’s 5th Anniversary FreeCon

In honor of SQL Solutions Group turning five years old, the four MCMs at SSG recently conducted a day of free training for the SQL community. Due to the many meetings going on Tuesday in conjunction with the PASS Summit, attendees were coming and going all day long.

The day started off with Ben Miller talking […]

By |November 10th, 2015|SQL Group|0 Comments

Much ado about GUIDs

How does one enforce referential integrity across separate databases, or servers for that matter?  The answer is simple—there is nothing native in SQL Server to enforce integrity outside of Primary and Foreign Keys which are scoped within a database.

However, you can go outside the box and use a Uniqueidentifier, often referred to as GUIDs (globally […]

By |October 20th, 2015|SQL Group|0 Comments

Using an Accidental DBA? We can help

“The Accidental DBA.” That almost sounds like the name of a movie. In our experience, if it were a movie, “The Accidental DBA” would probably be a horror flick.
That’s because, too often, people with some sort of technical background are asked to take on DBA responsibilities without having a DBA skill set. It’s kinda like […]

By |October 16th, 2015|SQL Group|0 Comments

PowerShell at FreeCon

We are getting ready to host a day of training on Oct. 27th to celebrate our 5th birthday. This is the SSG FREECON—it’s free and it’s tied to a conference!

Seattle is the place for PASS Summit 2015 and that is where our FreeCon will be. Registration is here. More information is here. This training is not an official […]

By |October 6th, 2015|SQL Group|0 Comments

Freakin’ out on XE at the FreeCon

Just a couple weeks ago I announced that SQL Solutions Group was getting ready to host a day of free training—a FREECON if you will—in Seattle as a prelude to the PASS Summit of 2015. You can read all about that here, with registration being here.

I am hopeful to see the room filled with people looking to […]

By |September 29th, 2015|SQL Group|0 Comments

FreeCon, October 27, 2015 Seattle

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

Combating SQL Injection

Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common? They are all recent victims of cyber-attacks – several of these are confirmed to involve SQL Injection. Even though the exact method used to penetrate the other systems has not been released, experts believe that […]

By |September 16th, 2015|SQL Group|0 Comments

SSMS: The SQL Server Solution Project

There is a great feature in SQL Server Management Studio that I do not see used very often, and that feature is the SQL Server Solution Project. SQL Server Solution Project has been around since SQL Server 2005 and is based on the framework from Visual Studio. A Solution is made up of one or […]

By |September 8th, 2015|SQL Group|0 Comments