Old, but stable
This Friday Steve Jones wants to know about the older versions you are running in your production environments. Are you still using SQL Server 2000?
Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
Working with Variables in SQL Server Integration Services
There are a number of ways that you can incorporated variables into your SSIS Scripts. Robert Sheldon demonstrates how.
Scaling Out
Steve Jones likes Service Broker as a scale out technology, but it hasn't caught on. He thinks more people should take a look at this technology and implement it in places where it fits well.
SQL Server Integration Services - Delay Validation
Using delay validation the designer can control the response of default behaviour of package validation which happens at design time and also at run time.
Come to see the SQL Server 2012 Launch at DevConnections
On Mar 26-29 in Las Vegas, the DevConnections conference is hosting a launch of SQL Server 2012. Come to the conference and learn more at the SQLServerCentral track.
How to use RunAs command for SSMS if option does not exist
In order to use your normal Windows login and your admin login to connect to SQL Server using SSMS you need to use the "Run as" feature. What do you do in the case of Windows 7 or Windows Vista where you can’t find the Run As Different User option?
Win an Amazon Kindle! Complete our Data Compression Survey
We'd like to find out what you think about SQL Server data compression. Complete this quick survey and you could win an Amazon Kindle. Complete the survey now.
Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
Data Gravity
Does data have gravity? Will the law affect how applications are built and deployed? Steve Jones has a few thoughts.
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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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