Hold it right there, you’re a user-defined aggregate
I've been trying out the windowing extensions (the OVER clause extensions and friends) with different kinds of functions (aggregate functions, first_value, last_value() etc), and thought
I've been trying out the windowing extensions (the OVER clause extensions and friends) with different kinds of functions (aggregate functions, first_value, last_value() etc), and thought
Two of the security features that folks have asked me about, especially since around 2002, is row-level and label security. Row-level security was present in
I'm always leery when I hear people say "statistics show that…" followed by whatever their opinion is. Scientists do it. And your users probably do it
After talking with folks about the SQLskills DBA Immersion training, one thing that always comes up is the fact that database developers feel left out.
After downloading CTP3, I immediately (well, almost immediately) went to set the options to view Books Online from local storage. You'all do know how to
So I was awake late last night and, lo and behold, there was a web link for Denali CTP3 posted on Twitter. Downloaded and installed
Just to let you know… I'll be speaking at the Portland, OR, SQL Server User Group meeting this month on July 28. The topic will
The next version of Data-Tier Applications is version 2.0. You can get a CTP of it today; where the CTP is located really gives away
So DAC 1.1 has been out for a while (since March 2, 2011) now. The big change is that the DAC "upgrade" process is now
About a week or so ago, I read a request for information about a SQL Server database management feature known as Data-Tier Applications, abbreviated as
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.