Here is a useful exam that you can administer in either 10 or 15 minutes, either oral or written, when you interview for hiring permanent or contract workers for jobs in SQL Server development or support. (This is not a test for SQL Data Base Administrators.)
2014-12-25 (first published: 2013-02-28)
15,702 reads
It's Christmas, so here are some Christmassy-themed songs to guess.
2014-12-25
6,956 reads
2014-12-24
104 reads
In the emerging "Internet of Things", there are multitudes of devices collecting data at differing sampling rates. Integrating this data so the data has a common granularity in time is important to not only allow for accurate analysis and mining, but it will also aid in reducing the amount of data to be stored and processed.
In this tip, we will demonstrate how to use the T-SQL AVG function and GROUP BY clause to transform data collected from two devices sampling at 100Hz and 40Hz to one row per second.
2014-12-24
7,922 reads
SSRS continues to use SET FMTONLY ON even though it has many problems. How can we cope?
2014-12-23
10,617 reads
Pester allows you to automate the testing of PowerShell scripts. It can test the output of a function as you develop it by validating simple data (scalars) and arrays, and allows you to focus on the one function you want to test by using 'mocking' to fake all the other functions and Cmdlets.
2014-12-23
7,027 reads
When a hospital’s mission-critical database fails at Christmas, disaster for the hospital – and its hapless DBA – seems certain. With less than an hour to spare before catastrophe, can the DBA Team save the day? This is a fictionalized true story.
2014-12-23 (first published: 2014-12-04)
17,000 reads
Learn how you can achieve better performance with linked list instead of a numbering column.
2014-12-22
9,165 reads
The term UPSERT has been coined to refer to an operation that inserts rows into a table if they don’t exist, otherwise they are updated. To perform the UPSERT operation Microsoft introduced the MERGE statement. Not only does the MERGE statement support the UPSERT concept, but it also supports deleting records. Greg Larsen discusses how to use the MERGE statement to UPDATE, INSERT and DELETE records from a target table.
2014-12-22
13,060 reads
Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.
2014-12-19 (first published: 2012-05-31)
15,170 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
hi , a new user wants to be able to add sql agent jobs...
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers