Back to All Articles

Articles tagged sqlserver:


Microsoft.SqlServer.Types–Getting it done.

SQL Server GeoSpatial types

Updated: June 11, 2020
Created: June 11, 2020

Read more

SQL Server Reporting Services (SSRS)–How to open SSRS Project

Ever try to open an older SQL Server Reporting Services (SSRS) project and do not know what product it opens with? SSRS and how to add/manage reports always seems to be a problem. Well, Visual Studio 2017 has an extension that you can use to open the older rptproj files. Give it a go.

Updated: March 3, 2019
Created: March 3, 2019

Read more

Cannot execute as the database principle

My database did not have had any owner before this issue. Execute this command in your database to set owner to sysadmin account

Updated: August 9, 2018
Created: August 9, 2018

Read more

SQL Server Profiler - Trace for your Application

Updated: May 29, 2017
Created: May 29, 2017

Read more

SQL Server 2008 Installation, not so quick

Before you rush to download SQL 2008 you may want to read the following KB article contained within this blog.

Updated: May 29, 2017
Created: May 29, 2017

Read more

SQL Server Triggers To Mirror a Table

I had a need to mirror any changes to one Sql Server table to another Sql Server table of a different name. Read on.

Updated: February 13, 2016
Created: February 13, 2016

Read more

Varchar vs NVarchar

Let’s talk about this to better understand some differences and benefits of using each.

Updated: June 26, 2015
Created: June 26, 2015

Read more

SQL Templates (in SQL Server Management Studio)

Updated: April 20, 2015
Created: April 20, 2015

Read more

SSMS Tools Pack

Updated: April 20, 2015
Created: April 20, 2015

Read more

SQL Execution (Enterprise Manager-QA) VS. .NET Execution

Updated: April 20, 2015
Created: April 20, 2015

Read more

SQL Server Find Field Value in Database

SQL Script that can be run in a database to return all tables and columns where...

Updated: April 20, 2015
Created: April 20, 2015

Read more

SQL Server Find SQL Object Names within a Database

Find SQL Object Names within a database.

Updated: April 20, 2015
Created: April 20, 2015

Read more

Cannot Resolve Collation Conflict

Updated: April 20, 2015
Created: April 20, 2015

Read more

SQL Server Comparing Tables

Learn how to compare two SQL Server tables

Updated: April 20, 2015
Created: April 20, 2015

Read more

List Indexes in SQL Server

Updated: April 20, 2015
Created: April 20, 2015

Read more

New SSDT Power Tools! Now for both Visual Studio 2010 and Visual Studio 2012

SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types - relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.

Updated: April 20, 2015
Created: April 20, 2015

Read more