A Billion Transactions
A billion transactions is a lot of activity on your database, however Steve Jones thinks more and more of us might see this on a regular basis. Microsoft's facilities group shows this to be the case.
2013-04-22
219 reads
Editorials
Excuses Execrating Excel
A bad workman always blames his tools. So does the entire western media, it seems, as poor old Excel gets it in the neck for some appalling calculation errors in economic papers.
2013-04-22
212 reads
Upgrading to 2012
Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week.
2013-04-19
425 reads
Asking for Interview Questions
When someone asks for interview questions on the web, it seems many people are upset. But should they be? Steve Jones points out there are different sides to this.
2013-04-18
395 reads
The Patch Wild, Wild West
Microsoft might be changing their patching process for applications. This has Steve Jones worried they may move towards an Apple/iOS like model, which would not be good for server systems.
2013-04-17
166 reads
Don't Be a Ghost
If you want to further your career, you can't be a ghost. Steve Jones talks about the ways in which so many people might end up hurting their careers by trying to keep their lives too private.
2013-04-16
296 reads
Bad Data Costs Lives
Either data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.
2013-04-15
197 reads
Modeling the Earth
Microsoft Research has a variety of interesting projects underway, including one to try and model the Earth. Many of these involve lots of data in some way, and would be interesting projects to work on, according to Steve Jones.
2013-04-15
110 reads
The DBA Office
The environment in which we work can have an affect on the way in which we work. Steve Jones asks today if you have a preference for your environment.
2013-04-12
213 reads
Don't Accept Defaults
All software has default values, some of which might not suit your environment. This is especially true with regards to security settings.
2013-04-11
91 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