12 Essential Steps After Installing SQL Server
Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.
2009-08-03
7,255 reads
Additional Articles
Script to check that backup files still exist for SQL Server
You have configured your database backup jobs without any problems. The backups themselves seem to be working, but are the files still where you think they are? How do you know they have not been moved, or worse, deleted to free up some space on your server? And when would you find out that the files were no longer there?
2009-08-03
2,892 reads
Attribute Discretization: Customize Grouping Names
Join BI Architect Bill Pearson as he continues to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.
2009-07-31
1,914 reads
Troubleshooting Performance Problems in SQL Server 2008
This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.
2009-07-31
4,809 reads
Creating and managing Analysis Services partitions
S partitions from the ground up, with advice on binding, merging, and selecting partition data.
2009-07-30
2,636 reads
Identify last statement run for a specific SQL Server session
The process to return the last query statement executed is quite straight-forward and works in all versions of Microsoft SQL Server since DMOs (dynamic management objects) were integrated into SQL Server.
2009-07-30
4,718 reads
Searching Unidentified Tables and Columns for Specific Content
You can't let a little thing like not knowing a database's structure keep you from your work. Without identifying tables and columns, you can still find specific values and columns.
2009-07-29
2,638 reads
Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)
There are three standard storage modes (MOLAP, ROLAP and HOLAP) in OLAP applications which affect the performance of OLAP queries and cube processing, storage requirements and also determine storage locations.
2009-07-29
2,524 reads
Checking SQL Server Agent jobs using Windows PowerShell
Checking for SQL Server Agent jobs and their status is part of your daily task as a DBA. How do we use Windows PowerShell to check for SQL Server Agent jobs?
2009-07-28
3,655 reads
SQL Server 2008 Learning Guide
This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases.
2009-07-28
3,337 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
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