SQL Saturday #167 – Columbus GA
The Columbus GA SQL Users Group will be hosting their first ever SQL Saturday on September 8th 2012 at Columbus...
2012-05-31
1,725 reads
Cross Database Views and Schema Binding
One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms. Sure...
2012-05-31
2,624 reads
Building a SQL Server Inventory – Part 2
Last time I went through my script to gather server information for my inventory. Today I’m going to go through...
2012-05-31
4,187 reads
Turn on Instant File Initialization for SQL Server Performance – With Video Demo
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-31
1,826 reads
SSIS Project Connection Managers
With the new Project Deployment Model in SSIS developers are gaining the benefit of a new design time only feature...
2012-05-31
3,805 reads
Denali – Day 31: Discontinue and Breaking/Behavior change features
Denali – Day 31: Discontinue and Breaking/Behavior change features Discontinue Features: As discussed about Deprecated will going to discontinue with that...
2012-05-31
1,762 reads
Never, Ever Use Clustered Indexes
This whole concept of the clustered index as a foundational structure within SQL Server is just plain nuts. Sure, I...
2012-05-31
2,388 reads
After August, I'm Done Traveling for the Year
I mentioned in a post over at my Goal Keeping DBA blog that I was not planning to attend the...
2012-05-31
2,115 reads
How to Give your .NET application HA
By David Postlethwaite
I was at a meeting the other week when someone mentioned that you could specify two SQL Servers...
2012-05-31
1,762 reads
Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1 (Republished)
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-31
3,883 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...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
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