Delivering Rapid Improvements to SSMS
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
Security is Getting Serious
Today Steve Jones notes that back doors could be inserted into chips, which would be a huge problem.
SQL Authentication Via AD Groups Part III: What About Orphaned Users?
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
You work in a shop that puts business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual for companies that use the SQL Server layer to perform
SQL Server 2016 - what's changed in the SQL Toolbelt?
Over recent months, Redgate’s development teams have been busy updating the tools in the SQL Toolbelt to support the valuable new functionality released with SQL Server 2016. To achieve this, most tools now support the syntax for SQL Server 2016’s key features, letting you do even more with them. Learn mor.
The Remote DBA
This Friday, Steve Jones asks if you're like to work remotely. With the trend moving this way, mostly for extra hours, maybe you'd like to move that way for most of your work time.
A Happy Birthday Present from Minionware
The Midnight DBAs and Minionware are having a birthday celebration. You can get your present of a free license today only.
SQL Server 2016 Temporal Table Query Plan Behaviour
For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Introduction to Row Level Security in SQL 2016
In SQL 2016 several new security features gets introduced which will help users to protect their data in many ways. New security feature Row Level Security (RLS) which implements the security inside the database itself, not at application level.
Stairway to DLM Dashboard Level 2: Setting up DLM Dashboard
Learn how to install and configure your initial DLM Dashboard instance.
Blogs
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Forums
Alamat kontak resmi BCA KCP Buaran Raya Telp:0817866887
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
Alamat kontak resmi BCA KCU BUKIT BARISAN Telp:0817866887
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
Alamat kontak resmi BCA KCU BUKITTINGGI Telp:0817866887
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
Question of the Day
Creating a JSON Document IV
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 YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers