Additional Articles

All authors

Technical Article

Migrating Microsoft Access Databases to SQL Server 2008

Microsoft Access is a very good database solution, but it has limits. While the portability of mdb and accdb files is convenient, there are advantages to moving to the less portable SQL Server solution. If you do have SQL Server, there's very little reason not to consider migrating your Access Databases. Not all custom-made Access applications easily lend themselves to a SQL Server solution so you'll need to do some analysis before choosing a migration path.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-07-26

3,430 reads

Technical Article

Managing SQL Server Service Broker Environments

SQL Server Service Broker (SSBS) is a new architecture (introduced with SQL Server 2005 and enhanced further in SQL Server 2008 and later versions) that allows you to write asynchronous, decoupled, distributed, persistent, reliable, scalable and secure queuing/message-based applications within the database itself. Arshad Ali looks at how we can manage, monitor and troubleshoot Service Broker environments.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-07-21

2,085 reads

Technical Article

Migrating SQL Server Databases – The DBA’s Checklist (Part 1)

It is a fact of life: SQL Server databases change homes. They move from one instance to another, from one version to the next, from old servers to new ones. They move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-07-18

3,616 reads

External Article

Yet Another SQL Strategy for Versioned Data

There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is never deleted, but superseded by a later version. Whilst this is conceptually simple, it has always made reporting the latest version of data complicated. Alex Kuznetsov joins the debate on the best way of doing this with an example using an indexed view and the filtered index.

2011-07-15

3,274 reads

External Article

Identifying PII Data to Lock Down in SQL Server - Part 1

We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business users on many of our downstream reporting, datawarehouse and standby servers. The rise of identity theft makes protecting this data imperative. DBAs are the custodians of this information and must protect it like we protect our own personal information. Recent publicity over the theft of Sony PSN data underscores both the economic and ethical importance of protecting personal data.

2011-07-14

2,864 reads

External Article

Questions About SQL Server Distribution Statistics

Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.

2011-07-13

2,132 reads

External Article

Questions About SQL Server Distribution Statistics

Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.

2011-07-12

2,173 reads

Technical Article

Monitor SQL Server Replication Jobs

The Replication infrastructure in SQL Server is implemented using SQL Server Agent to execute the various components involved in the form of a job (e.g. LogReader agent job, Distribution agent job, Merge agent job) SQL Server jobs execute a binary executable file which is basically C++ code.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-07-11

3,267 reads

External Article

How to develop TSQL Code

The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored procedures in TSQL. Phil Factor is well-known for his more lengthy and complex stored procedures, so we asked him to explain in more detail how he goes about developing things without the comfort of Visual Studio.

2011-07-08

3,997 reads

All authors

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

When the Token Meter is Zero

By dbakevlar

Comments posted to this topic are about the item When the Token Meter is...

Understanding Temp Tables and Table Variables in SQL Server

By sabyda

Comments posted to this topic are about the item Understanding Temp Tables and Table...

The Data API Builder MCP Server Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data API Builder MCP...

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers