Use of Identity Property to Resolve Concurrency Issues
This article describes how the identity property was used to resolve contention in a database
Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management
In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Management? Check out this tip to learn more.
SQLServerCentral Runs sp_Blitz - Performance Part 2
The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.
Zettabytes and Beyond
The growth of data, and the sheer scale of data we store and manage is stunning. Steve Jones looks at the rates of growth these days.
Query Tuning, Encryption, and more at SQL Intersection
Grant Fritchey is speaking about query tuning, Steve Jones talking about Encryption, Paul Randal telling you how to make SQL Server faster. All at SQL Intersection. Join us in April.
Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment
SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware. How, then, can you investigate the query plans being generated for slow-running queries on a customer's production server when you can neither access the server, nor recreate the database from a backup?
Populating a Vertically Filtered Replicated Table
Vertical filtering of a large replicated table introduces the potential for unwanted transactions to be pushed to the subscriber. This article talks about how you might avoid this.
Stop, Smell, Smile
On this quiet Friday, Steve Jones skips a poll and talks about life. This editorial was originally published on Jun 6, 2008. It is being republished as Steve is on vacation.
The Power of the SQL Server Database Owner
I have a couple of databases supporting applications. The first application requires that it's user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions? Check out this tip to learn more.
Serious Storage
Steve Jones talks about the serious storage that EMC is bringing to the Vatican library.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Godean | Tlp/Wa:0818751777
Jl. Godean No.Km 4,5, Area Sawah, Nogotirto, Kec. Gamping, Kabupaten Sleman, Daerah Istimewa Yogyakarta...
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers