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

Archives: September 2015

Session Event Metadata

There is a wonderful amount of metadata available to be perused in Extended Events. Part of the trick is to know where and how to find it. I started to dive into the investigation of this metadata with the exploration of the Deployed Extended Event Session Settings discussed here.… Read more

2 comments, 1,297 reads

Posted in SQL RNNR on 29 September 2015

Fixing MSI errors during patching


Patching is an activity that is frequently performed by DBA’s. It is the responsibility of a DBA to keep the SQL servers up and running all times and ensure the  Cumulative Updates, Service Packs, out of band hot-fixes are applied to the instances.It’s hardly a 30 min task if…

Read more

0 comments, 2,824 reads

Posted in Kruti's SQL Blog on 29 September 2015

SQL Server – Various methods to generate unique number sequence

Hi all, Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number …

Continue reading Read more

0 comments, 541 reads

Posted in Kapil Blogs on 28 September 2015

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 619 reads

Posted in The Voice of the DBA on 28 September 2015

Exercism

I’ve been looking to work on my programming skills a bit and try some new languages. I’d like to grow my career in a few different ways, as well as investigate where some of the new languages and platforms might be useful for data analysis. As I’ve talked to some… Read more

0 comments, 313 reads

Posted in The Voice of the DBA on 28 September 2015

Intro to the Social DBA with a bit of #SQLHelp

Are you a Social DBA?  No I don’t mean that you are a DBA and attend a myriad of merry mixers, networking events, post SQLSaturday soirees, or PASS parties. (Yet that’s a great way to make connections, and build your professional database of career-complimenting contacts.) I’m talking about putting… Read more

0 comments, 2,086 reads

Posted in Pearl Knows on 28 September 2015

Deployed Session Settings

You may recall that I wrote about how to look at the deployed session metadata. Today, I will be talking about deployed sessions again. And it may even be considered metadata as well. This time around, the metadata I will be discussing is a little bit different but will build… Read more

2 comments, 1,026 reads

Posted in SQL RNNR on 28 September 2015

SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it can be kind of hard to remember which connection is which. Fortunately all of the information you need is readily available.

Connections in the Object Explorer

Notice that for each… Read more

0 comments, 1,887 reads

Posted in SQLStudies on 28 September 2015

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and me in the Washington, DC area for our 4-day Advanced SSIS classroom training course. This course will be held December 7-10 in Reston, VA (just outside of DC). I’ve… Read more

0 comments, 1,912 reads

Posted in Tim Mitchell on 28 September 2015

Power Bi, PowerShell and SQL Agent Jobs

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how I create the most useful daily report for DBAs – The SQL Agent Job report. You can get the scripts and reports here

This gives a quick overview of the… Read more

3 comments, 2,932 reads

Posted in SQL DBA With A Beard on 28 September 2015

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's standard, but lobbied against it. I instead prefer separating job titles from project roles.

Why?

"Architect" as an IT role descriptor carries an appropriate level of technical expertise and…

Read more

2 comments, 356 reads

Posted in SQL Tact on 28 September 2015

Table partitioning

What is partitioning.

To start with partition is the feature provided by SQL server in which very large tables are split between multiple files and file-groups for ease of access and faster retrieval/ update purposes.
Consider a table which consists of millions of records. When we insert all the records…

Read more

0 comments, 330 reads

Posted in Kruti's SQL Blog on 28 September 2015

SQL Saturday as an Attendee

Last week I did something that many people have already done. However this was my first experience, and I really enjoyed it. We’ll see if I get to do it again.

I went to SQL Saturday #441 – Denver as an attendee. I hadn’t submitted to speak, but I spent… Read more

0 comments, 537 reads

Posted in The Voice of the DBA on 25 September 2015

Thoughts on the 2015 PASS Election

We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim Ford – for participating, and congratulations to Jen, Ryan, and Tim for being elected. PASS surely can’t survive without volunteer leaders and it’s great to see that we continue… Read more

0 comments, 531 reads

Posted in SQLAndy on 25 September 2015

The Extended Event GUI

In the previous article in this series I shared the basics around assembling an XEvent session. The method used in that article was via TSQL script. In this article, I will introduce the Extended Events GUI. While I prefer to use TSQL to create and manage my sessions, the… Read more

2 comments, 2,025 reads

Posted in SQL RNNR on 25 September 2015

SQL Server SSIS: ReplaceNull

One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have the operator similar to ISNULL () in T-SQL. To be more exact, there was such an operator, but it works in… Read more

0 comments, 819 reads

Posted in Forrards Group Database Blog on 25 September 2015

Azure Virtual Machine Blog Series – Changing the size of a VM

I’m starting a new blog series on Microsoft Azure Virtual Machines, and my goal is to write blog posts exclusively on Azure VM/SQL Server related topics.Here is the 1st post –

“Changing the size of a VM”

When creating an Azure VM to host your SQL Server, you have an… Read more

2 comments, 1,965 reads

Posted in SQLSailor.com on 24 September 2015

I Was Once a Very Crappy Carpenter + SQL Bolts to Buzzwords

Tonight I spoke to Dr. Alkadi's CMPS 411 class, which was hijacked by the Hammond .NET User Group onsite at Southeastern University! Thanks once again to Sparkhound who sponsored!

Here's the slide deck for my presentation, which combined two topics I wanted to talk about. The first, I Was Once…

Read more

0 comments, 463 reads

Posted in SQL Tact on 24 September 2015

Use SCOPE_IDENTITY()–SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I ran across a question on Facebook, of all places, the other day. Someone had asked a friend how to return a value from a procedure and assign… Read more

3 comments, 2,407 reads

Posted in The Voice of the DBA on 24 September 2015

Assembling a Session

Up to this point, I have taken a lot of time to discuss the various components of Extended Events. There is good reason for that. The components I have discussed are essential pieces of Extended Events and are critical to building useful sessions.

Previously, I only touched lightly on the… Read more

1 comments, 382 reads

Posted in SQL RNNR on 24 September 2015

Newer posts

Older posts