Adding PK Exceptions to SQLCop Tests
In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.
Solving Tempdb Issues
A simple change might solve some of those tempdb issues various customers experience.
Performance Surprises and Assumptions : DATEADD()
Aaron Bertrand explores yet another scenario where a date/time function seems to cause the optimizer to behave unexpectedly.
Use Tools
One of the great things about IT is that we have so many tools to help us do our jobs. We can even build tools as needed. So why don't more IT people take advantage of this?
A Lifetime of Software
Today Steve Jones wants you to look forward in your career. Do you enjoy working with software and technology? Do you plan on doing this for the rest of your career?
Data Mining Part 40: Big Data and Microsoft Data Mining
This article will introduce about big data and HDInsight and Hadoop.
SQL Server Security Audit Basics
SQL Server Server Audit has grown in functionality over the years but it can be tricky to maintain and use because it lacks centralization and analysis tools. It can do a fast and lightweight audit of many different activities including DML and DDL at both Instance and Database Levels - even the work of the DBAs. How do you check logins and permissions? How do you script an enterprise-wide audit solution? How can you hope to analyse the log data you get? Feodor Georgiev gets you started.
Don’t Miss Out on an Opportunity to Connect
There are people in our lives that we want to connect with, so why don't we?
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
BCA KCP Alaydrus TLP/WA 08216977701
Jl. Alaydrus No.47 & 47 A, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...
BCA KCP Menteng TLP/WA ( 08216977701 )
Jl. HOS. Cokroaminoto No.83, RT.3/RW.5, Menteng, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota...
BCA KCU PANGERAN JAYAKARTA TLP/WA (08216977701)
Jl. P Jayakarta Komp. No.127, Mangga Dua Sel., Kecamatan Sawah Besar, Kota Jakarta Pusat,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers