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

Archives: September 2015

Calculate Percentage Share in Power BI (DAX)

What’s my share? Calculating percent share of the total is a common need. Let’s see how to calculate this in Power BI using DAX.

I’ll start with a table containing population by country as shown below. I’m using Power BI Desktop for this demonstration. You can use the same formula… Read more

7 comments, 12,779 reads

Posted in Sam Vanga on 29 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,419 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, 4,335 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, 582 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, 691 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, 384 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,215 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,112 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,953 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,946 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

5 comments, 3,098 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, 396 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, 401 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, 578 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, 581 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,140 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, 910 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, 2,316 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, 537 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,501 reads

Posted in The Voice of the DBA on 24 September 2015

Newer posts

Older posts