Database Normalization Basics
The task of Database Normalization doesn't have to be painful, especially if you follow Old Mother Celko's Normalization Heuristics.
2014-04-23
6,652 reads
Articles
Microsoft Azure SQL Database Security - Firewall Configuration
Marcin Policht reviews security related challenges of Microsoft Azure Software as a Service-based SQL Database, focusing in particular on the SQL Server and database-level firewall access control functionality and methods that can be employed to implement it.
2014-04-22
3,521 reads
Automating Database Restores
This article describes a way to automatically restore multiple database backups from a directory.
2014-04-21
6,203 reads
Monitoring SQL Server: An Interview with David Bick
Simple-Talk sat down with David Bick, a Red Gate Product Manager, to discuss his work on SQL Monitor and why passively monitoring SQL Server just doesn’t cut it anymore.
2014-04-21
4,290 reads
SQL Saturday #305: Dallas, BA Edition
Please join us on Saturday, May 3rd, 2014, as both business analysts and IT professionals come to learn and network with experts for the first SQLSaturday Business Analytics edition. Please register while space is available
2014-04-18
310 reads
Unexpected View Performance
Views that use implicit conversion to return result sets may use a different query plan than the statement executed in query analyzer.
2014-04-18 (first published: 2011-01-11)
13,895 reads
SQL Server Performance Tuning Using Wait Statistics: A Beginner's Guide
This beginner's guide to Wait Stats by Jonathan Kehayias and Erin Stellato is a free PDF download brought to you by SQL Skills and Simple-Talk.
2014-04-18
5,338 reads
XML Schema validation in SQL Server
An introduction to the XML Schema Collection and XML validation.
2014-04-17
19,623 reads
Call for participants in deployment process research
The Red Gate Database Delivery team is looking for people willing to participate in UX sessions for an exciting, brand new product, with $50 Amazon vouchers for participants.
2014-04-17
2,901 reads
Explaining the Calculations of Probability and Importance for Complex Association Rules in SSAS
The output from the Association Rules data mining model in SSAS 2012 can be difficult to understand, especially when the generated rules become more complex. In this tip we go through an example to provide a better understanding.
2014-04-17
3,252 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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...
Forums
BCA KCP Muara Karang Utara Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Pluit Karang Utara Blok I No.36 1. S Kav. 53, Pluit, Kecamatan...
BCA KCP Burangrang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Burangrang No.44, Burangrang, Kec. Lengkong, Kota Bandung, Jawa Barat 40262
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595
BCA KCP Gatot Subroto Telpon/wa:0813.7887.595.Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit...
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