Locking Your Disk
How important is disk encryption to you? Do you think about all those replicated or copied databases on laptops? Let us know.
Microsoft SQL Server 2008 - Change Data Capture – Part 2
Part 2 of this article illustrates how to enable Change Data Capture on a database, on a table and how SQL Server tracks the data changes of the CDC enabled table.
The Stewardship Approach to Data Governance: Ch 7
This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
Coping with No Column Names in the SSIS OLEDB Data Source Editor
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
New Isolation Levels Available in SQL Server 2005
One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.
SQL Server 2008 - Table Valued Parameters
In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.
Writing Outer Joins in T-SQL
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
Ideas for SQLServerCentral.com
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
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