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

Latest Blog Posts

Reblog: October 17 to October 23

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 48 reads

Posted in StrateSQL on 24 October 2014

Find all triggers in a SQL Server Database

What Are Database Triggers?

Do you know what triggers lurk in your database?

Triggers can be implemented to enforce business rules or referential data integrity in database applications.

There are even triggers that allow data modifications to multiple base tables of a view. I have actually used this in the… Read more

2 comments, 88 reads

Posted in WaterOx SQL on 24 October 2014

Writing Fair and Useful Editorial Reviews Is Hard Work

One of my original goals was to be more reporter than editorial writer, but I’ve found that the editorial part is important too, though much harder to do. I’ve spent quite a few hours this week trying to write editorial comments to preface the summaries I’m doing of the minutes… Read more

0 comments, 269 reads

Posted in SQLAndy on 23 October 2014

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first before proceeding here.  This article is intended as a first of two part follow-up to that article.

Now that you… Read more

0 comments, 78 reads

Posted in SQL RNNR on 22 October 2014

Off to London

Today I’m off across the Atlantic again. SQL in the City 2014 kicks off in London and I have 3 talks to give on Friday. Plus a keynote.

Today is keynote practice, last minute packing, and then off to the airport for my flight overnight to London. This will be… Read more

0 comments, 125 reads

Posted in The Voice of the DBA on 22 October 2014

Wishing You a Very Happy Diwali

Wishing You a Very Happy Diwali…………….

KAHI TIMTIMAHAT HAIN DIYO KI, KAHI SHOR HAAN ATHISBAZI KA

CHAMAK HAAN DIL MAIN, UMEEDO KI KHANAK HAAN

MITHAIYO KA ANAND HAAN, PATHAKO KI JHADI HAAN

YE JEET HAAN SACH KI, YE JASAN HAAN DIWALI KA

 

??????? : ??????  ???? ?? ???? ??…

Read more

0 comments, 222 reads

Posted in AshishSharePointBlog on 22 October 2014

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures.

In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can be some combination of coach, assistant coach… Read more

1 comments, 74 reads

Posted in SQLStudies on 22 October 2014

SQL Server Upgrade Preconference at PASS Summit 2014

Please join my associates and I for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology Evangelist from Microsoft, will spend the morning…

Read more

0 comments, 96 reads

Posted in SQL Server BI Blog on 21 October 2014

Have You Contributed to “Argenis Without Borders”?

So, I’m a little behind the ball on all of this.  And others have already blogged about it:

For those that don’t know, earlier this… Read more

0 comments, 78 reads

Posted in StrateSQL on 21 October 2014

Consolidating Email Accounts

I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either of my sqlpass.org email accounts, please use this instead:

kbriankelley

{at}

acm

{dot}

org

I have been slow to respond at times to the other accounts, because I don’t check… Read more

0 comments, 116 reads

Posted in Databases – Infrastructure – Security on 21 October 2014

Webinar: Presenting to the PASS Database Administration Virtual Chapter

In this Webinar, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a dynamic re-indexing script, created based on his real-life experience from managing high performing database systems.

Read more

0 comments, 130 reads

Posted in SQLFeatures on 20 October 2014

Minion Reindex arrives this Friday!

Edit: Minion Reindex has arrived, and it’s getting fantastic notes! The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA.  We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client…

Read more

0 comments, 187 reads

Posted in SQL Awesomesauce on 20 October 2014

SQL Server Security Benchmarks

If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:

The Mission of the Center for Internet Security is to enhance the security readiness and response of public private sector entities, with a commitment to excellence through collaboration.

CIS produces consensus-based, best practice secure…

Read more

0 comments, 92 reads

Posted in Databases – Infrastructure – Security on 20 October 2014

Last Weeks Top “Reading” Links #105

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 100 reads

Posted in StrateSQL on 20 October 2014

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring :-

1) Break the Mirroring Read more

0 comments, 93 reads

Posted in MSSQLFUN on 20 October 2014

Database Lifecycle Management

There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every application and if you do a similar search, there aren’t very many people talking about Database Lifecycle Management at all. Why not? I’m positive you’re deploying a database with… Read more

4 comments, 177 reads

Posted in The Scary DBA on 20 October 2014

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal (b/t) and finally felt like… Read more

2 comments, 94 reads

Posted in SQLStudies on 20 October 2014

SQL Server TABLESAMPLE

Using TABLESAMPLE in SQL Server

SQL Server has several ways for you to limit the number of records returned from a query.  For example, the AdventureWorks [sales].[salesorderdetail] table has 121,317 rows loaded in sequential order starting with SalesOrderDetailID 1.  By Using a top 1000 clause I can limit the results… Read more

0 comments, 104 reads

Posted in Business Intelligence and Enterprise Architecture on 20 October 2014

Reducing the size of the distribution database & improving transactional replication performance: Part 3

Part 1 of this series of articles looked at the intricacies of SQL Server transactional replication, and made the observation that the clean-up mechanism treats publications as a collective.  Part 2 looked at how differing distribution job schedules can cause unnecessary bloating in the distribution database.

The final (and much… Read more

0 comments, 153 reads

Posted in Chris Jenkins' Blog on 20 October 2014

Older posts