The Standard Limitation
SQL Server Standard Edition only supports 64GB of RAM and it's our fault. Or is it, and is this a reasonable number? Steve Jones has a few thoughts today.
2013-08-07
390 reads
Editorials
Separation of Duty
We want to ensure that the data we gather accurately reflects the state of some system or event. The analysis should decide how we interpret the data gathered. Neither should influence the other.
2013-08-06
117 reads
DEF CON SQL
An impromptu hacking session, in response to an inexplicably-changed password, reminds Rodney Landrum of some valuable lessons for every DBA.
2013-08-05
112 reads
2013-08-05
187 reads
The School Year
This Friday Steve Jones looks forward to the rest of the year. It's almost time for school and do you have plans? Should you be making some plans?
2013-08-02
98 reads
The Human Touch
Humans are often the weakest links in any computer process, but we do need human input. Steve Jones talks about a few issues, and how we should be changing our workflow to reduce issues.
2013-08-01
116 reads
Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
2013-07-30
265 reads
How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
2013-07-29
535 reads
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
2013-07-29
145 reads
Data Farming
Another spy story involving data that's not true, and perhaps not plausible, but it makes Steve Jones think about data shadows.
2013-07-25 (first published: 2008-10-13)
250 reads
Blogs
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Data Viz in Fabric Notebooks
Lots of people have created Power BI reports, using interactive data visualizations to explore...
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