Uploading New R Library Packages

Somehow I have become the R DBA at my job which I don’t mind, I plan on taking Microsoft’s Professional Program on Data Science to be familiar with it.  But recently I’ve had to upload files to our R servers which the first time wasn’t too bad.  Copy these files to six different servers but […]

Read More »

Monitoring Availability Groups Part 2 – SQL Agent Alerts

This entry is part 2 of 2 in the series Monitoring Availability Groups

In my last post on monitoring Availability Groups I covered looking at Perfmon Counters now we take a look at getting alerts from SQL Agent. When it comes to checking on your Availability Groups one of the easiest ways to keep track at a high level of the health of the them is to setup […]

Read More »

T-SQL Tuesday #90 – Shipping Database Changes

At my first official DBA job, I was being trained the current DBA on deploying stored procedures.  They had system where you received a ticket with the SQL file attached.  You proceed to see if the procedure existed and if it did.  You right click on it and look at who had access to it […]

Read More »

Monitoring Availability Groups Part 1 – Perfmon Counters

This entry is part 1 of 2 in the series Monitoring Availability Groups

Monitoring Availability Groups can be tricky.  The DMVs don’t update the log_send_rate and redo_rate all the time especially if nothing is happening so if you try to use those for calculations when monitoring you could false results worse yet pages in the middle of the night.  In order to calculate the log_send_rate and redo_rate you need to […]

Read More »

Running SQL Scripts Against Multiple Servers Using PowerShell

In this post I’m going to share a function I use run scripts against multiple instances of SQL servers and run the data into a GridView. I use this mainly for a replacement of the CMS feature of running against a folder and to put the output to a GridView that I can sort and […]

Read More »

Paul Randal Mentor Me?!

Paul Randal recently won the award for “Person You’d Most Like to be Mentored By” in the Tribal Awards, now Paul is offering to mentor 3 men and 3 women for two months. To get a chance of getting mentored by Paul, you simply need to apply by writing a blog post about why you should be considered […]

Read More »

T-SQL Tuesday #53 – Why So Serious? No SQL Authentication Use Your Own Account

At a previous job I had several developers that had passwords for SQL authenticated accounts for systems that would give them more access than they needed when they had Windows accounts that would give them enough to troubleshoot issues.  Our trick was to write a login trigger that would block any SQL Authentication accounts that […]

Read More »

Exam 70-458 – Objective 7 – Configure and deploy SSIS solutions

This entry is part 7 of 8 in the series Exam 70-458

  Troubleshoot data integration issues Performance issues Performance Counters (http://msdn.microsoft.com/en-us/library/ms137622.aspx) Connectivity issues Execution of a task or transformation failed Logic issues Demonstrate awareness of the new SSIS logging infrastructure (http://msdn.microsoft.com/en-us/library/ms140246.aspx) Troubleshoot a failed package execution to determine the root cause of failure Troubleshoot SSIS package failure from an invalid datatype Implement break points To see […]

Read More »

Exam 70-458 – Objective 8 – Build Data Quality solutions

This entry is part 8 of 8 in the series Exam 70-458

  Install and maintain Data Quality Services Installation prerequisites (http://msdn.microsoft.com/en-us/library/gg492277.aspx#PreInstallationTasks) Server – Min 2 GB, Rec 4 GB+ RAM, SQL Server 2012 Database Engine Client – .NET Framework 4, IE 6.0 SP1+ Use Data Quality Server Installer Install Data Quality Services Run DQSInstaller.exe Add users to the DQ roles (http://msdn.microsoft.com/en-us/library/hh213045.aspx) IN DQS_MAIN database add to roles […]

Read More »

Exam 70-458 – Objective 5 – Extract and transform data

This entry is part 5 of 8 in the series Exam 70-458

  Design data flow Define data sources and destinations (http://technet.microsoft.com/en-us/library/ms140080%28v=sql.110%29.aspx) Distinguish blocking and non-blocking transformations Integration Services: Performance Tuning Techniques Understanding SSIS Data Flow Buffers (SQL Server Video) Use different methods to pull out changed data from data sources Change Data Capture Run sys.sp_cdc_enable_db on database then for each table run sys.sp_cdc_enable_table There are CDC […]

Read More »