2001-07-09
3,585 reads
Articles
Using Stored Procedures in SQL Server
If you’re a programmer, you know that SQL is becoming more and more prevalent. Here’s a guide to one of its basic building blocks the stored procedure.
2001-07-09
4,417 reads
Career Advice for DBAs
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
2001-07-06
9,102 reads
FAQ : Why can't I see my text field's data when using ADO?
In this FAQ of the week, you'll see one of the most common bugs that programmers run into when programming using ADO against a SQL Server.
2001-07-06
23 reads
Taming the Stateless Beast: Managing Session State
Running a Web farm means managing session state across servers. Since session state can't be shared across a Web farm with Internet Information Services 5.0, a custom solution is required. One such solution using a tool called the session manager is described here.
2001-07-06
1,721 reads
XP_ENUM Stored Procedures
Digging a little deeper this week into extended stored procedures, we find the xp_enum procedures. These
procedures require no parameters but provide a handy bridge to the operating system and is extremely helpful for developers.
2001-07-05
3,486 reads
SQL Server CE: New Version Lets You Store and Upda
Handheld device users need to be able to synchronize with a main data store when it's convenient and, preferably, when the back-end database server isn't busy. SQL Server 2000 Windows CE Edition allows you to build a traveling data store that can be displayed and run on a variety of devices. SQL Server CE supports a subset of the full SQL Server package, and can be used as a standalone server or in tandem with SWL Server and IIS.
2001-07-05
802 reads
Tame Those Strings - Part 6
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
2001-07-04
8,826 reads
The Guru's Guide to T-SQL
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
2001-07-04
5,401 reads
PASS 2001 North America - Register and Save $500
Unique access to more than 110 sessions and 80 presenters, including SQL Server users and Microsoft developers. Educational tracks include: data warehousing and business intelligence; developing web-enabled and line of business solutions; enterprise database administration and deployment; and, professional development. Register today and get a great return on your SQL Server investment!
2001-07-04
3,665 reads
Blogs
Master the Foundational Basics
By Brian Kelley
It tells us to take the time to master the foundational basics of whatever...
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...
Forums
ssrs order of operation question
hi i need "sample size" in my report's 4th data region which is a...
Query Network Protocols from T-SQL or PowerShell
Hello experts, I want to be more organized about the SSL certificates we have...
Occasional Sql Server 2019 slowness (upgraded from 2014) -- please help...
Hi everyone, We recently upgraded our server to Sql Server 2019 (15.0.2125.1 (X64) on...
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