Buy a $10 Raffle Ticket to Help Katie
Not a happy story, but if you've got a child I suspect it will be easy to decide to buy...
2007-07-12
1,386 reads
SQLAndy
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
598 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
903 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
713 reads
70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
731 reads
Debugging Stored Procedures in VS 2005
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk...
2007-06-27
1,364 reads
Celko Cites Steve Jones
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL...
2007-06-20
1,412 reads
GO More than Once?
SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and...
2007-06-18
1,367 reads
Tampa Code Camp 2007
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go...
2007-06-12
1,341 reads
Mirrored Backups Posted on SSC
This was fun to run through, nice to see MS adding features even if in my view they didn't quite...
2007-06-12
1,325 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