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

Latest Blog Posts

Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected performance issues on a well running system. This session will empower you to quickly and accurately detect real culprits without causing…

Read more

0 comments, 95 reads

Posted in SQLFeatures on 5 October 2015

Implementation of Data Compression – SQL Server

Data Compression

Data Compression is feature of Microsoft SQL Server to reduce the size of table on the basis of Duplicates, Null & Zeroes. It’s a process of reducing size of database & its objects by increasing CPU cycle and reducing I/O effort.

Types of Database Compression

· Row Compression Read more

0 comments, 60 reads

Posted in MSSQLFUN on 5 October 2015

Trace Flags in Azure SQL Database

One of the ways that you take more direct control over your SQL Server instances is through the use of trace flags. There are a number that people recommend you enable by default. Prior to Extended Events for example, I’d say you should turn on trace flag 1222 in order… Read more

0 comments, 59 reads

Posted in The Scary DBA on 5 October 2015

SQL Source Control and Git–Getting Started

It seems as though Git is taking the world by storm as the Version Control System (VCS) of choice. TFS is widely used in the MS world, but Git is growing, Subversion is shrinking, as are most of the other platforms.

As a result, I wanted to do a quick… Read more

0 comments, 102 reads

Posted in The Voice of the DBA on 5 October 2015

Backup Deployed Sessions

There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth of information. A good bit of this information happens to be the metadata for Extended Events, and another bit of this information is tied to the metadata for deployed Sessions.… Read more

0 comments, 51 reads

Posted in SQL RNNR on 5 October 2015

The powerpoint for my SQL Server Security Basics session

Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned along the way a bit later. But in the mean time I promised I would make the PowerPoint for my SQL Server Security Basics session available on my blog and… Read more

0 comments, 80 reads

Posted in SQLStudies on 5 October 2015

SQL Saturday 467 - Precon - Query processing and internals

Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased to say that on Friday 5th December i will be presenting a day long pre-con on Query Processing and internals at SQL Saturday 467 in Southampton.

We will be spending…

Read more

0 comments, 75 reads

Posted in Dave Ballantynes blog on 4 October 2015

Presentation Downloads from SQL Saturday Columbus GA 2015

Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL Server! And even bigger congrats to those of you who use Google maps and were still able to find the brand new event location at the Troy State University Riverfront…

Read more

0 comments, 94 reads

Posted in SQL Tact on 3 October 2015

Atomic Commit In Multiple Files Of SQLite Database

Introduction to Atomic Commit

In my previous post, we have discussed how to view and analyze SQLite BLOB data and know why BLOB data is important in SQLite database. Now, in this blog section we will know the role of atomic commit in SQLIte multiple files. SQLite has become the…

Read more

0 comments, 90 reads

Posted in Zora's SQL Tips on 3 October 2015

Standing Desk Update

It’s been a long time since I wrote about my workspace, however I made a change recently. This was the "short term test" situation I set up a couple years ago:

After just using boxes for a few days, I decided I liked things and got monitor stands. However… Read more

1 comments, 146 reads

Posted in The Voice of the DBA on 2 October 2015

Speaker of the Month: October 2015

Working on my third year of “Speaker of the Month” posts now. The good news, I haven’t run out of people to award it to. Most months, if I’ve been able to go to a community event or two, I have three or four candidates.  Same this month.

Speaker of… Read more

4 comments, 113 reads

Posted in The Scary DBA on 2 October 2015

019 – 24 HOP Questions Answered - WaterOx Consulting

  24 HOP Questions Answered In WOxPod!, episode # 019 – “24...

The post 019 – 24 HOP Questions Answered appeared first on WaterOx Consulting.

Read more

0 comments, 117 reads

Posted in WaterOx SQL on 2 October 2015

SET Operations and Metadata

Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover. This is more of a subset of those concepts in that this applies to more than one of the core concepts, but it isn’t really a stand-alone topic. This is… Read more

0 comments, 92 reads

Posted in SQL RNNR on 2 October 2015

Free learning materials

If you are new to a technology, you might want to have a place to get you started. It would be great if can be free and can guide you through from beginner to expert. Microsoft Virtual Academy can be here to help, if you are going learn SQL server,…

Read more

0 comments, 163 reads

Posted in Dennis's SQL Blog on 2 October 2015

Oregon SQL Saturday 2015 Keynote

This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th.  Microsoft is once again moving to a front-line position as a leader in Business Intelligence and Analytics and the Corporate Vice President who leads that team will be speaking live…

Read more

1 comments, 86 reads

Posted in SQL Server BI Blog on 2 October 2015

Step by Step SSIS–Aggregate Transformation TIP #118


Dear Friends,

In the series of step by step SSIS tutorial this is another post. In this post we will see Aggregate Transformation. I am pretty much sure you are aware of aggregation. Although , Just wanted to share that aggregation operation in generally memory expensive operation.

So,… Read more

0 comments, 708 reads

Posted in Rajat Jaiswal-337252 on 2 October 2015

SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing

Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple secondaries known as ‘replicas’. The secondary replicas allow direct read-only querying or can enforce connections that specify ‘ReadOnly’ as their Application Intent using the new feature called Read-Only routing which…

Read more

0 comments, 869 reads

Posted in - SQL in simple style on 1 October 2015

SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists

Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an availability group listener, to an available readable secondary replica. I find this little script very useful when I want to automate and and same time while limiting the human input…

Read more

1 comments, 96 reads

Posted in - SQL in simple style on 1 October 2015

SQL Server – Script to generate Read-Only Routing URLs

If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should keep this script to generate URLs to be used in Read-Only Routing configuration. Connect to each replica in your AlwaysOn cluster and run this script to get the read_only_routing_url for…

Read more

1 comments, 93 reads

Posted in - SQL in simple style on 1 October 2015

New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication

Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios. Availability Groups does not allow you to have more than one writeable version of the data at any given time. Replication is the only native component or feature in SQL…

Read more

Older posts