Skip to content
SQLInsight

SQLInsight

We Do SQL Right!

  • What’s New
  • Power BI Gallery
  • PowerPoint Downloads
  • About Us
  • Contact Us
  • Home
  • SQL Administration

Category: SQL Administration

Import tab delimited data files directly into SQL Server via SSMS

June 1, 2016 Steve Schneider

Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer…

Read more

SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL Administration, SSISData Import, SSIS, tab delimitedLeave a Comment on Import tab delimited data files directly into SQL Server via SSMS

SQL Saturday May 2016, Jacksonville, FL

April 1, 2016 Steve Schneider

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRSLeave a Comment on SQL Saturday May 2016, Jacksonville, FL

Querying a remote server w/ SQLCMD

February 8, 2016 Steve Schneider

So, sometimes you need a simple way to run (often the same) command on two different servers at the same time. Perhaps setting up a Linkserver is difficult, or simply too time consuming. Here’s an option. Try SQLCMD.

SQL 2008, SQL 2012, SQL AdministrationLeave a Comment on Querying a remote server w/ SQLCMD

Importing (old) SSIS packages into VS 2012

December 6, 2015 Steve Schneider

SQL 2012 introduced a new deployment model.  Many of us, for various reasons didn’t move along with Microsoft…and continued to use and deploy the old SSIS Packages (.dtsx) … even to SQL 2012.  So, that being the case, how do…

Read more

SQL 2012, SQL Administration, SSISpackages, projects, SSISLeave a Comment on Importing (old) SSIS packages into VS 2012

SQL Saturday Jacksonville, May 10, 2014

April 28, 2014 Steve Schneider

Hey, everyone! There’s a great event here in Jacksonville, Florida. It’s coming in May. It is like a mini Tech-ed. Free Food. Great Technical presentations.  Click the picture to the right to register! Lots of networking. Fellowship. Swag. After hours…

Read more

Azure, Career, Performance Tuning, PowerBI, SQL AdministrationLeave a Comment on SQL Saturday Jacksonville, May 10, 2014

Reading an SSAS cube thru SQL using MDX

July 23, 2013 Steve Schneider

Do you need the ability to read a cube, but you want to read it thru SQL?  And, why would you do this?  Well, for example, suppose you wanted to email the results of a certain MDX query…and you didn’t…

Read more

SQL Administration, SSASMDX, SQL, SSAS, SSRSLeave a Comment on Reading an SSAS cube thru SQL using MDX

List out all the database users and the roles they are members of…

July 2, 2012 Steve Schneider

Needing to figure out which users in which database are members of roles? You’ve come to the right spot! Try this code…

SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on List out all the database users and the roles they are members of…

Script version of SSMS “Sql Server Agent” Job Activity Monitor

June 25, 2012 Steve Schneider

Are you tired of “right-click” “refresh” on the job monitor?  Want a single, simple script to tell you what step a job is at?  Try this script:

SQL 2000, SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Script version of SSMS “Sql Server Agent” Job Activity Monitor

Sql Binaries location, SessionTimeout, Sql Version

June 6, 2012 Steve Schneider

OK…this is a ‘strange’ post… That is because the script i have for you today is a real ‘utility’ script… it does three things that occasionally come in REAL handy! It tells you the location of your SQL binaries. It…

Read more

SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Sql Binaries location, SessionTimeout, Sql Version

Sql Server Status

May 31, 2012 Steve Schneider

What’s the first thing you do when you get a report of a problem on one of your servers? In my case… i run this following script that gives me a quick overview of all the top counters of interest.

SQL 2005, SQL 2008, SQL AdministrationLeave a Comment on Sql Server Status

Posts navigation

1 2 3 Next
Copyright SQL Insight 2017 © All rights reserved.
Business Era by mProThemes