Latest Blog Posts
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
Today is keynote practice, last minute packing, and then off to the airport for my flight overnight to London. This will be… Read more
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
??????? : ?????? ???? ?? ???? ??…
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
So, I’m a little behind the ball on all of this. And others have already blogged about it:
- Donate to Doctors Without Borders, and I’ll Wear…
- Still time to get a SQL Server tattoo
- Argenis and the unicorn hoodie
- Argenis Without Borders
For those that don’t know, earlier this… Read more
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:
I have been slow to respond at times to the other accounts, because I don’t check… Read more
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…
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
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
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
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
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
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
Here is a riddle for you…
You are requested to move a database from an old server to a new server. As a professional and experienced DBA, you prepare a checklist of actions to take, you script everything, you document your plan, and, of course, you test it before doing… Read more
Below is the list of linkedin articles which I liked most. These articles gives you lot of motivation.
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more
What is a Foreign Key?
A foreign key is a link between 2 tables that is used to enforce referential integrity in the database.
For example, if you have an order and a customer table, there is probably a logical relationship between the 2… Read more