2001-05-15
1,906 reads
Articles
2001-05-14
1,457 reads
New SQL Server 2000 Data Types
In the latest release of SQL Server, Microsoft has added a number of new data types to expand the functionality of SQL Server.
2001-05-14
6,779 reads
Removing Duplicate Rows
Ever have duplicate rows of data returned in a query? This article by Neil Boyle examines different techniques for removing duplicate rows.
2001-05-14
11,792 reads
Securing Your SQL Server
Poorly managed SQL Server Security can not only leave your SQL Server vulnerable, but also leave your NT Server and network open to attacks.
2001-05-14
6,512 reads
2001-05-13
2,553 reads
2001-05-13
2,771 reads
2001-05-11
3,001 reads
Changing Where The SQL Server Tools Are Installed
Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,822 reads
Minimizing the Number of Log Backups
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,366 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
DBATools in a agent job
Hi Dbatools is used to copy table data from domain a to domain b...
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers