The Costs of Data
Information is free, but data certainly has a cost. Especially as there are real costs to storing and managing large volumes of bits and bytes.
2013-08-22
117 reads
Editorials
Always Abstract
When developing your code, should you use views? There are reasons why you might choose to do so, or not do so, however Steve Jones thinks you should consider abstracting your systems.
2013-08-21
156 reads
Guidance
When you are looking to help someone improve performance on a system, there isn't a single set of steps you provide. The advice and guidance you provide will vary, depending on the situation.
2013-08-20
108 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2013-08-16 (first published: 2008-09-26)
540 reads
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2013-08-15 (first published: 2008-10-20)
387 reads
Lossy data and incorrect data
Your copier could change data when creating an image. Phil Factor has some words of caution.
2013-08-14
191 reads
Patch Problems
A few recent Patch problems have Steve Jones concerned about the directions we are going with software.
2013-08-13
146 reads
2013-08-12
110 reads
Review Your Code
Steve Jones notes that SQL Injection is still a problem, and while it might be for some time to come, we should not be adding to the issues. Learn how to write secure code.
2013-08-12
531 reads
Would You Choose SQL Server?
This Friday Steve Jones has a poll asking how you feel about SQL Server for your own projects, or even your company's projects. Is it a given you'd use SQL Server?
2013-08-09
257 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