New Unlocked CPUs From Intel
AnandTech has an interesting review up about some new models of Core i5 and Core i7 processors that are designed...
2010-05-28
1,448 reads
Glenn Berry
Kalen Delaney Speaking In Denver on June 9, 2010
Well-known SQL Server MVP and author Kalen Delaney (blog) will be speaking about SQL Server Plan Cache and Recompilation on...
2010-05-26
943 reads
SQL Server Utility Script From 24 Hours of PASS
I had a good time giving my presentation and demo of SQL Server Utility during the fourth hour of the...
2010-05-19
2,202 reads
SQL Server 2008 R2 RTM Cumulative Update 1 (Build 1702) Released
I also just discovered that Microsoft releasedSQL Server 2008 R2 RTM CU1 yesterday. It is Build 1702, and it contains...
2010-05-18
3,073 reads
SQL Server 2008 SP1 Cumulative Update 8 Released
Microsoft has releasedSQL Server 2008 SP1 CU8 (Build 2775). There is no corresponding CU for the RTM branch of SQL...
2010-05-18
1,309 reads
Some Data Compression Commands for SQL Server 2008 and 2008 R2
One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data...
2010-05-17
493 reads
Some Data Compression Commands for SQL Server 2008 and 2008 R2
One of the more interesting and valuable features in SQL Server 2008 R2 Enterprise Edition (and Datacenter Edition) is data...
2010-05-17
1,231 reads
Five Things SQL Server Should Drop
Joining in the current meme started by Paul Randal (blog | twitter), here is my list of five features or settings...
2010-05-11
12,523 reads
Some New DMV Queries for SQL Server 2008 R2
I was spelunking around in SQL Server 2008 R2 today, after looking at a PowerPoint presentation by Madhan Arumugam about...
2010-05-11
1,781 reads
Finding Enterprise Only Features in Your SQL Server 2008 Database
Microsoft added a new DMV, sys.dm_db_persisted_sku_features to SQL Server 2008 that you can use to determine whether you have any...
2010-05-10
1,142 reads
Blogs
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
App-Consistent MongoDB Snapshots Across Multiple Pure Storage FlashArrays
Introduction When you’re running MongoDB at scale with data distributed across multiple Pure Storage...
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
Forums
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Getting The Database Name
Comments posted to this topic are about the item Getting The Database Name
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers