You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
Which big tech company has the most servers? It doesn't matter, but how you show the data can matter. Steve Jones talks about a skill data professionals should develop.
A way to save holiday records that can be created as needed into a search-able calendar table.
Performing an upgrade is a complex and often risky project. A successful upgrade can provide an organization with a modern platform for development and production. An unsuccessful upgrade can cause lost time and money, and it can create a bad perception for the future.
This paper documents approaches and tools that can help DBAs and developers to achieve successful and mostly painless upgrade of SQL Server databases from Microsoft® SQL Server® 2000 or SQL Server 2005 to SQL Server 2008 (or SQL Server 2008 R2).
Today Steve Jones talks about how you might be able to help keep your employees excited and happy with their jobs.
In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.
Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content.
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
A webinar from the PASS Performance VC on Aug 3, 2010
A survey shows the majority of IT administrators have snooped for data on their networks. Steve Jones reminds us to be professionals, each and every day.
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
I have 13 restricted views in my EDW DB. 6 of them are created...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers