-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Bert Wagner

Bert Wagner is a Business Intelligence Developer at Progressive Insurance. He enjoys solving challenging data transformations with T-SQL and optimizing for query performance. In addition to BI development, Bert loves building ASP.NET MVC web apps and building Internet of Things projects.

The Forgotten Fourth SQL Server Recovery Model

SQL Server recovery models define when database transactions are written to the transaction log.   Understanding these models is critical for backup and recovery purposes as well as for how their behaviors impact the performance of queries.

Today we’ll examine the differences between SQL Server’s three official recovery models as well… Read more

1 comments, 146 reads

Posted in Bert Wagner on 24 April 2018

In-Memory OLTP: A Case Study

Watch this week’s episode on YouTube.

When In-Memory OLTP was first released in SQL Server 2014, I was excited to start using it.  All I could think was “my queries are going to run so FAST!

Well, I never got around to implementing In-Memory OLTP.  Besides having an… Read more

1 comments, 1,826 reads

Posted in Bert Wagner on 17 April 2018

3 Essential Tools For The SQL Server Developer

This post is a response to this month’s T-SQL Tuesday #101 prompt by Jens Vestergaard. T-SQL Tuesday is a way for SQL Server bloggers to share ideas about different database and professional topics every month.

This month’s topic is about what essential SQL Server related tools you use on… Read more

1 comments, 177 reads

Posted in Bert Wagner on 10 April 2018

Power Query vs DAX: In The Power BI Kitchen with Eugene Meidinger

Watch this week’s episode on YouTube.

In this week’s video with Power BI expert Eugene Meidinger, we’re in the kitchen learning about Power BI.

Power BI has two languages available for working with data: Power Query and DAX.

Power Query is most useful cleaning and preparing your data… Read more

1 comments, 1,720 reads

Posted in Bert Wagner on 3 April 2018

AT TIME ZONE: The easy way to deal with time zones and daylight savings time

Many people think daylight savings time was created to help align the hours that the sun is up with our waking hours so farmers and school children didn’t have to be outside in the dark.  Or something like that.

Well let me fill you in on a little secret –… Read more

5 comments, 3,122 reads

Posted in Bert Wagner on 27 March 2018

How To Steal Data Using Second Order SQL Injection Attacks

One misconception some people have about SQL injection is that it can only happen when concatenating a user input parameter directly into your dynamically built query string:

While this type of injection flaw is easy to spot, there are other less direct ways an injection attack can occur.

Second Order…

Read more

0 comments, 3,808 reads

Posted in Bert Wagner on 20 March 2018

Full Automatic Tuning: SQL Server 2026’s Most Killer Feature

This post is a response to this month’s T-SQL Tuesday #100 prompt by the creator of T-SQL Tuesday himself, Adam Machanic.   T-SQL Tuesday is a way for SQL Server bloggers to share ideas about a different database or professional topic every month.

This month I’m going down the science… Read more

1 comments, 139 reads

Posted in Bert Wagner on 13 March 2018

2.5 Ways Your ORM Is Vulnerable To SQL Injection

Someone recently told me that they don’t need to worry about SQL injection because they are using an ORM.

Oh boy.

ORMs don’t automatically prevent SQL injection

Object-relational mapping (ORM) tools allow developers to easily access an application’s data layer without having to write lots of redundant code.

 

Most… Read more

0 comments, 2,280 reads

Posted in Bert Wagner on 6 March 2018

Splitting It Up: Side by Side Queries In SSMS

There are times when you are writing a query while referencing another piece of information: the results of another query, a variable value, a webpage, etc…

If using two monitors you can have a query window on each as a reference, or you can resize two query window tabs so… Read more

0 comments, 44 reads

Posted in Bert Wagner on 27 February 2018

OR vs UNION ALL – Is One Better For Performance?

Today I want to show you a trick that could make your queries run faster.

It won’t always work, but when it does everyone will be impressed with your performance tuning prowess.  Let’s go!

Watch this week’s episode on YouTube.

Our Skewed Data

Let’s create a table and insert…

Read more

0 comments, 24 reads

Posted in Bert Wagner on 20 February 2018

What I Do When I’m NOT Writing SQL

This post is a response to this month’s T-SQL Tuesday prompt created by Aaron BertrandAdam Machanic created T-SQL Tuesday as a way for SQL users to share ideas about interesting topics every month.  This month’s topic is “Your passions outside of SQL Server”.


Getting away

I spend… Read more

1 comments, 21 reads

Posted in Bert Wagner on 13 February 2018

“How do I contribute to dbatools?” with Drew Furgiuele

This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.

If you don’t use dbatools yet, what are you waiting for?  It’s an amazing community project that will help you automate your SQL Server work with… Read more

0 comments, 18 reads

Posted in Bert Wagner on 6 February 2018

The Fastest Way To Locate Errors In Your SQL Query

Photo by N. on Unsplash

In about 60 seconds you will never debug error messages in SQL Server Management Studio the same way again.

Coming from a .NET background, I’m used to receiving relatively helpful error messages that point me to the precise location of the error in my code: Read more

1 comments, 1,346 reads

Posted in Bert Wagner on 30 January 2018

Inverted Polygons? How to Troubleshoot SQL Server’s Left Hand Rule

Last week we looked at how easy it is to import GeoJSON data into SQL Server’s geography datatype.

Sometimes your source data won’t be perfectly formatted for SQL Server’s spatial datatypes though.

Today we’ll examine what to do when our geographical polygon is showing us inverted results.

Watch this… Read more

0 comments, 170 reads

Posted in Bert Wagner on 23 January 2018

Importing GeoJSON Earthquake Data Into SQL Server

A significant portion of Yellowstone National Park sits on top of a supervolcano.  Although it’s not likely to erupt any time soon, the park is constantly monitored for geological events like earthquakes.

This week I want to take a look at how you can import this earthquake data, encoded… Read more

0 comments, 264 reads

Posted in Bert Wagner on 16 January 2018

I Have A SQL Login – Why Can’t I Connect?

This post is a response to this month’s T-SQL Tuesday prompt created by Arun SirpalAdam Machanic created T-SQL Tuesday as a way for SQL users to share ideas about interesting topics. This month’s topic is “Your Technical Challenges Conquered”.


DBA Skills 101: SQL Logins

While writing last… Read more

0 comments, 232 reads

Posted in Bert Wagner on 9 January 2018

A Better Way To Script Database Objects

Photo by Andy Beales on Unsplash

Happy New Year! My New Year’s resolution for 2018 is to help you become a better SQL developer.

I want to start off with that today by showing you a much better way to generate database object change scripts.

Prefer video?  Watch this week’s… Read more

8 comments, 3,057 reads

Posted in Bert Wagner on 2 January 2018

SQL and NOT SQL: Best of 2017

Photo by Rick Meyers on Unsplash

With only a few days left in 2017, I thought it would be fun to do a year in review post.  Below you’ll find some of my top 5 favorites in a variety of SQL and non-SQL related categories.  Hope you enjoy and I’ll… Read more

0 comments, 186 reads

Posted in Bert Wagner on 26 December 2017

How To Create Multi-Object JSON Arrays in SQL Server

Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:

And output them so that the Cars and Toys data would map to a multi-object JSON array like so:

Prefer visuals instead of text?  You can watch this week’s… Read more

0 comments, 580 reads

Posted in Bert Wagner on 19 December 2017

Reducing the Number of Reads in Your Queries

“A-Bridged” – reducing reads – get it?  I’m sorry you’re reading this.  Photo by Jamie Street on Unsplash

In last week’s post, we went over how one of best ways to improve query performance was to reduce the number of reads that your query has to do.

Less reads typically… Read more

0 comments, 84 reads

Posted in Bert Wagner on 12 December 2017

Older posts