What Will I See at SQL Connections?
The SQL Connections conference will be held this November in Las Vegas and Steve Jones is attending. See what he's interested in viewing at the event.
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
Introduction to Dimension Security in SQL Server Analysis Services SSAS 2005
I have seen the tip Dynamically Control Data Filtering in SQL Server Reporting Services Reports which showed how to leverage a SQL Server database table to filter sales data based on the user running the report. I have a similar requirement to implement dynamic filtering except my data is in a SQL Server Analysis Services (SSAS) cube and the users query the data with a variety of different tools. How can I implement dynamic security in my case?
Issue with SQL Server 2K5 SP3 CU5
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out one issue / bug we found with CU5.
PowerShell 101 for the DBA – Installing PowerShell
Many DBAs have heard about the new scripting technology from Microsoft, but have yet to really dive right in. You...
T-SQL Challenge #13
Take T-SQL Challenge #13, Break a batch of invoices into multiple parts based on rules.
Tuning the Performance of Change Data Capture in SQL Server 2008
Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
What's Your Education Worth?
Most of us learn on the job, but is that the best way? If you could learn faster at a cost, would you pay it? Steve Jones talks a little bit about what he has done and what he would do today in today's editorial. What is a SQL Server education worth to you?
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers