How to Get SQL Server Security Horribly Wrong
It is no good doing some or most of the aspects of SQL Server security right. You have to get them all right, because any effective penetration of your security is likely to spell disaster. If you fail in any of the ways that Robert Sheldon lists and describes, then you can't assume that your data is secure, and things are likely to go horribly wrong.
Opening Up Data
Tim O'Reilly, head of O'Reilly publishing, has been an advocate of better date movement in the world. Steve Jones has a few comments on an interview he gave earlier this year.
The Case for Scalar-valued, User-defined Functions in T-SQL
Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...
How do you work with databases?
How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.
How To Calculate Behavioral Streaks in SQL Server Data
In this tip, Tim Smith demonstrates how to measure a behavioral streak with SQL Server, an important skill for determining ROI and extrapolating trends.
Not Only a Meeting of Minds, but of Open Minds.
In which Phil Factor claims that professional application development requires a broad knowledge base.
The Service Pack Fiasco
The recent SQL Server 2014 Service Pack fiasco wasn't the first, but hopefully it won't be the last.
Database Source Control Workshop: Philadelphia, PA
Redgate and Ike Ellis are hosting a database source control workshop in Philadelphia PA, on June 4, 2015. Learn all you need to put your development databases in source control, using the version control system of your choice. Register while space is available.
Making Data Analytics Simpler: SQL Server and R
R an SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have jumped the hurdle of reliably and quickly transferring data between R and SQL Server you are ready to discover the power of a relational database when when combined with statistical computing and graphics.
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 Buaran Raya Hub.0851•8812•0691
BCA KCP Buaran Raya Hub.0851•8812•0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Griya Utama HUB/CS 08216977701
Ruko Puri Mutiara, Jl. Griya Utama B Blk. D No.1-2, Sunter Agung, Kec. Tj....
BCA KCU Magelang Telp/wa 085169998765
Telp/wa 085169998765 Jl. Ahmad Yani No.1, Magelang, Kec. Magelang Tengah, Kota Magelang, Jawa Tengah...
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