Server Name and SQL Server Name
I have, in the past had the need to rename a server, either because the server has been named incorrectly...
2012-01-10
797 reads
TSQL Tuesday #26 or #23 – Identity Crisis
This second chance, gives me the opportunity to finally talk about a topic that has been on my to-blog list for quite some time. I hope this post will...
2012-01-10
11 reads
TSQL Tuesday #26 or #23 – Identity Crisis
The first opportunity of this New Year to participate in TSQLTuesday, we have been invited by David Howard (blog) to...
2012-01-10
896 reads
How safe are your secrets?
We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems....
2012-01-10
652 reads
T-SQL Tuesday #26 - Second Chances - Correlate Missing Index with Related Query
Everybody deserves a second chance in love, life, and in TSQL as well! Now that it's the beginning of a New...
2012-01-10
5,172 reads
SQL Server – Maintaining different environments
A busy Database Server and application development environment can have – Sandbox, Dev, Test, QA, Staging, Production .
Maintaining multiple environments requires...
2012-01-10
2,659 reads
Making Schema Changes in a Replication Topology
I've noticed in the forums there have been a number of people inquiring about making schema changes in a replication...
2012-01-10
5,809 reads
Orlando IT Pro Camp
The Orlando IT Pro Camp marks our third event after Tampa and South Florida. As with the prior IT Pro...
2012-01-10
992 reads
January 2012 Speaking Events
It has been a quiet past few months while my family has adjusted to having
two new additions (twins!), but...
2012-01-10
929 reads
DBAs in Denver
I have a friend looking for a production DBA in Denver, so if you’re interested, email me at SQLServerCentral.
They need...
2012-01-09
783 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers