Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
The Data Loading Performance Guide
This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune and optimize the bulk loading process.
8 Clicks to What Changed
Finding out what happened on a SQL Server instance can be a challenge for even experienced DBAs. SQLClue, a new tool by longtime SQL Server expert Bill Wunder can help. We have a short case study that shows you how this tool can help.
Instrumenting Code - Database Weekly (Feb 23, 2009)
In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...
Retrieving Deadlock Graphs with SQL Server 2008 Extended Events
Learn how to get deadlock graphs from the SQL Server 2008 default system_health session with Extended Events.
SQL Saturday Comes to Pensacola
SQL Saturday comes to Pensacola, June 6, 2009. Read on to get more information and sign up for a one day, free training event.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Can you shrink your transaction log files to death?
can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers