Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

CONTEXT_INFO and efficient mass update on a large table with a trigger

Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.

Use test database in a simple recovery mode. Create two tables and fill them… Read more

0 comments, 0 reads

Posted in Forrards Group Database Blog on 1 September 2015

Experiences of Submitting a PASS 2015 Session

The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or so selected to speak at the conference (…and as a quick aside I also note a reasonably… Read more

0 comments, 45 reads

Posted in Mr. Fox SQL on 31 August 2015

Upgrading a SQL Azure Database to v12

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

I was looking to test some of the Azure v12 capabilities, but I needed to upgrade a database. Here’s a quick look at how.

In the old portal,… Read more

0 comments, 70 reads

Posted in The Voice of the DBA on 31 August 2015

Populating My DBA Database for Power Bi with PowerShell – Server Info

Following my last post about using Power Bi with my DBA Database I have been asked if I would share the PowerShell scripts which I use to populate my database. They are the secondary part to my DBADatabase which I also use to automate the installation and upgrade of all… Read more

0 comments, 54 reads

Posted in SQL DBA With A Beard on 31 August 2015

SSC Editorial: The Problem Solver

The Problem Solver. Ever scoffed at personality types? Surely none of us are just one thing, but often we are mostly one thing, or at least one thing that is easily identified as being a big part of who we are. Writing this I was thinking about two things… Read more

0 comments, 66 reads

Posted in SQLAndy on 31 August 2015

The default instance has a name

The default instance actually has an instance name. It’s MSSQLSERVER. This is probably familiar to a lot of you but hold on because I’m going to go a little bit deeper. When we connect to a default instance we typically just put down the server name right? Is that because… Read more

2 comments, 59 reads

Posted in SQLStudies on 31 August 2015

Your presentation matters! Do it right!

This weekend I was invited over at SQLSaturday Oslo to speak about SQL Server Indexing. I ran into Boris Hristov there and we ended up in a discussion about presentation design, and how it plays a huge role in getting your message across to your audience. As a speaker myself,… Read more

0 comments, 51 reads

Posted in DotNine SQL Server and more on 31 August 2015

Buffer Pool Extension in SQL Server 2014 part 2: benchmark testing

Let’s take a closer look at how we can speed up the system’s performance using the Buffer Pool Extension. For testing I will use a virtual machine with 4 GB RAM. I created a separate database with one table. The table has 2 columns [id] and [n]. The first column… Read more

0 comments, 59 reads

Posted in Forrards Group Database Blog on 31 August 2015

At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez

Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at work, could attend only Pre Conference event on Wednesday, skipping the events on Thursday, Friday and Saturday.

The Preconference event I attended was "SQL Server Optimization and Tuning" by Benjamin…

Read more

0 comments, 55 reads

Posted in SQL and SQL Only on 31 August 2015

Dimensional Modelling in Lucidchart vs Visio: Part 1

Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model data. As a Certified Microsoft Professional, my default modelling tool has always been Microsoft (MS) Visio and sometimes, Visual Studio. However, I’ve… Read more

0 comments, 82 reads

Posted in Select SIFISO Blogs on 30 August 2015

syntax error in textheader of stored procedure - Cause and Solution

Hi Folks,

Comments play an important part in writing any code. Especially when somebody else reads your code. So the other day I was writing a stored procedure and some comments on top to list the tasks being performed inside the stored procedure. We are using sql server 2005 and…

Read more

0 comments, 62 reads

Posted in Everyday IT Challenges on 30 August 2015

Pluralsight Authoring – Upcoming Course

I am super excited to announce that I have recently been accepted as an author for Pluralsight.

My audition was on Monitoring AlwaysOn Availability Groups and was accepted on the first pass :) the clip discussed monitoring replication latency something I’ve blogged about here and here.

In the… Read more

0 comments, 94 reads

Posted in Anthony Nocentino's Blog on 29 August 2015

5 Tips for #PowerBI

After a couple months of fun with Power BI, I’ve picked up a few little tricks along the way that have helped me to be able to create some pretty cool data visualizations and dashboard reports. Here are five Power BI tips and tricks that you may find useful as… Read more

0 comments, 106 reads

Posted in SQL with Dustin Ryan on 29 August 2015

How to create first basic package with SSIS ? tip #113

Dear friends,

In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in practical session where we will try to create a basic simple package.

The example which we are creating is well known Export data from SQL SERVER… Read more

2 comments, 76 reads

Posted in Rajat Jaiswal-337252 on 29 August 2015

Row-Level Security in SQL Server and Azure

Row-Level Security (RLS) is a new feature of SQL Server 2016 and Azure SQL Database that enables data access control based on the users executing those queries: if a user isn’t authorized to access certain rows in a table then those rows are automatically filtered out by the database engine.… Read more

0 comments, 85 reads

Posted in Gorandalf's SQL Blog on 28 August 2015

SQL Saturday Baton Rouge 2015 Recap

SQL Saturday Baton Rouge 2015 was our 7th annual event, but we're still learning lessons. Here's my official Planning Committee Chair's recap of the event.

Here's one of the big new things we did this year:
  • We have a large, four-building facility for our event with multiple entry points. We…

Read more

0 comments, 78 reads

Posted in SQL Tact on 28 August 2015

Using Power BI with HDInsight Part 2: Power BI Desktop and Hive

With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help you take advantage of those big data investments. If you need to set up a cluster to work with, check out my previous posts on Setting Up an HDInsight Cluster… Read more

0 comments, 85 reads

Posted in DataOnWheels on 28 August 2015

Sixty Days to Summit–Are You Ready?

In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a couple of months away, this is a great time to start making preparations to ensure that you get the most out of your Summit experience.

Download and install… Read more

0 comments, 73 reads

Posted in Tim Mitchell on 28 August 2015

017 – Thinking Like A Manager - WaterOx Consulting

Reading Time: 2 minutes

Thinking Like A Manager In WOxPod!, episode # 017 – “Thinking Like...

The post 017 – Thinking Like A Manager appeared first on WaterOx Consulting.

Read more

0 comments, 132 reads

Posted in WaterOx SQL on 28 August 2015

Master Data Services 2016 CTP 2.2 - Explorer functionality quick fix

Microsoft has recently released SQL Server 2016 CTP 2.2. I was concerned about the Master Data Services and was exploring the new features. I got surprised when I see that Explorerfunctionality was not working. Generally it is used to manage members for Entities and Hierarchies. It is one of…

Read more

0 comments, 82 reads

Posted in SQL & BI on 28 August 2015

Older posts