Certification Should Be Required
Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments
2001-11-04
5,616 reads
Articles
2001-11-02
1,265 reads
XML for SQL Server 2000: Optimizing Your Performance
The XML features of Microsoft® SQL Server® 2000 and the subsequent XML for SQL Server 2000 Web releases enable a whole new class of XML-aware applications. This article shows you how to improve the performance of this new feature.
2001-11-01
2,241 reads
Review of Data Compare v.151
In this product review Andy takes a look at Data Compare, the second of three products in the SQL Bundle available from Red-Gate software. It's a very handy program that lets you compare data between two tables and optionally generate sql statements to syncronize the data. An interesting alternative to replication!
2001-10-31
8,789 reads
Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
2001-10-30
6,166 reads
SQL Server 6.5: Index Statistic Details
This article examines how index statistics are used in SQL Server 6.5
2001-10-30
3,298 reads
SQLXML 2.0 (XML for SQL Server 2000)
Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base.
2001-10-29
6,623 reads
Easily Create Insert Scripts with AutoInserts
One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!
2001-10-26
5,831 reads
2001-10-26
1,436 reads
Scrubbing Data With DTS : Part 2
Chances are, if you've dealt with any type of data, you know you
rarely receive the data in perfect condition. In this second article in the series on cleaning data, Brian Knight shows you how to scrub data with a more advanced method.
2001-10-25
4,989 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
A Few Good DBAs
You can't handle the truth!! (about data integrity) A few good database administrators https://www.helpmasterpro.com/blog/a-few-good-database-administrators/...
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers