Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.
2011-12-30 (first published: 2009-07-30)
51,541 reads
Start your 2012 off right with a free day of training in Colorado Springs. Bring the kids as well, as the venue is very family friendly.
2011-12-30 (first published: 2011-12-06)
1,122 reads
Check out this tip to learn about the SELECT @@VERSION command in SQL Server.
2011-12-30
4,818 reads
SSIS features log-providers that can write to five different types of logging destinations; three of them are files, one is the 'dbo.sysssislog' table, and the last is the Windows Event Log.
2011-12-29
4,361 reads
2011-12-29 (first published: 2010-06-09)
8,908 reads
There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
2011-12-29
2,878 reads
This blog, explores ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer space.
2011-12-28
2,595 reads
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
2011-12-27
4,678 reads
2011-12-27 (first published: 2010-06-02)
11,247 reads
I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
2011-12-27
2,872 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
Comments posted to this topic are about the item RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers