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
Looking to advance your career? Trying to get started as a DBA? Some advice from a DBA with ten years working with SQL Server
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.
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.
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.
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.
Continuing with Steve Jones series on string manipulation, this article looks at an interesting facet of the SELECT operator.
Steve Jones's review of this classic and reference. A must-have for every SQL Server DBA.
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!
In the last installment of this column, at the end of a long and erudite discussion on clonation, I introduced the sad but instructive story of Dolly. As a real scientist, I was conducting experiments on disconnected data features applied to intermittent applications.
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Hi - I'm looking for advice regarding the best & quickest way to establish...
Hello. I am looking for a tool Data cleansing/conversion, was recommended HPE any...
I have a query that runs in a job to check on orphaned users....
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers