Whack a Database
The SQL Server team is looking for feedback on deleting databases and Steve Jones gives a few ideas.
2007-11-06
90 reads
Editorial
2007-11-05
735 reads
The Personal Checksum
An interesting method of preventing restaurant fraud and a poll for other ways to determine the accuracy of data. This editorial was originally published on Nov 2, 2007. It is being republished as Steve is on vacation.
2012-08-30 (first published: 2007-11-02)
265 reads
Unstructured Data
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
2007-11-01
125 reads
2007-10-31
2,788 reads
October Energy Update
A recap of the world of energy from the previous two months. Steve looks at solar, wind, nuclear, and more.
2007-10-30
49 reads
Mining or Profiling
The more data you have, the better you should be able to predict something. Or at least that's one of the things that I learned while studying economics. If we could actually gather enough data about someone or some system, we could determine what the most likely outputs of the system will be. In the […]
2007-10-29
77 reads
What's Fair
If you read my recent editorial called Get Some Help, you realize that I didn't get any World Series tickets from the sale on the Colorado Rockie's web site. Not to berate the subject, but some friends and I had an interesting debate on how the situation was handled and what could be done differently.
2007-10-26
50 reads
Mini-Me
Will the next version of Windows be a "Mini-Me" version of Vista? Who knows, and it's too early to tell, but apparently there's a mini-kernel version of Windows 7, the one after Vista, which fits into 25MB on disk. That's a touch lower than the 4GB that Vista takes up. Granted it's not a full […]
2007-10-25
105 reads
Get Some Help
The vast majority of us never work on high volume systems. And I mean high volume systems, like backing a web server that gets millions of hits in a few minutes, which might result in tens of millions of database queries in the same amount of time.
2007-10-24
299 reads
Blogs
Bicep Your Elastic Jobs
I posted on Terraform and Azure SQL last year but wanted to see what...
3rd Party Applications Have Issues
By Kevin3NF
As a SQL DBA, what do you do when a vendor application has performance...
Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL...
Forums
The On-Call Load
Comments posted to this topic are about the item The On-Call Load
Two Table Hints
Comments posted to this topic are about the item Two Table Hints
Database Dashboards in Azure Data Studio
Comments posted to this topic are about the item Database Dashboards in Azure Data...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers