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.
This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.
This chapter explains the Naïve Bayes algorithm. How does it works, what information is displayed.
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.
Accurate statistics about the data held in tables are used to provide the best execution strategy for SQL queries. but if the statistics don't accurately reflect the current contents of the table you'll get a poorly-performing query. How do you find out if statistics are correct, and what can you do if the automatic update of statistics isn't right for the way a table is used?
dbWarden is a comprehensive monitoring and alerting solution for SQL Server 2005 or newer. It features an emailed Health Report and includes email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth.
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.
The performance of 'extract, transform, load' (ETL) processes for large quantities of data can always be improved by objective testing and experiment with alternative techniques. The cause of poor performance can sometimes be surprising.
SQL Server Management Studio is where most SQL scripts and queries are run, and although it does a decent job, it doesn't provide much help storing, sharing and managing the scripts particularly in the context of a team. Red Gate is considering building functionality into SSMS to help its users consume and share queries and scripts. Please help us by completing this short survey to help us define the requirements.
SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists…in this book I focus on what I thought were the ten most important new features for Production DBAs.
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers