Management at Scale
Could you manage 20,000 databases? That's how many servers each person at Facebook has to manage in operations.
SQL Best practices, policies and code-smells.
Phil factor warns against taking SQL Coding 'best-practices' too much at face value. They can, at best, assist in reviewing code, and at the worst they can prevent the developer from finding the best solution.
SQL Saturday #241 Cleveland, OH
SQL Saturday is coming to Cleveland on February 8, 2014. Join us for a free day of SQL Server Training and Networking. There will also be paid-for pre-conference sessions on Feb 7 featuring Argenis Fernandez and Allen White.
Managing SSIS Security with Database Roles
SQL Server 2012 introduced the new project deployment model for Integration Services. This tip will guide you through the process of setting up security for the SSIS 2012 catalog.
A Versioning system for SSRS
Use SSRS to be create its own lightweight report version control system
Common Checks
This Friday Steve Jones wants to know what types of things are you checking for on your instances. What items can cause you issues if you don't proactively monitor for them.
The SQL Server Sqliosim Utility
The sqliosim utility is provided with SQL Server to test the I/O stability and 'correctness' of a server. It is generally used before installing SQL Server in order to ensure that new hardware can handle your expected loads. Bob Sheldon explains what it is and how to use it.
Too Much Choice
More information and choice are generally good things, but there can be problems. Steve Jones notes that we can't let freedom paralyze us.
Search multiple SQL Server Error Logs at the same time
The code in this tip will show how to use two system stored procedures to identify all iterations of a given string in the available SQL Server error logs since a specific point in time.
Software in 2014
What's the state of software in 2014. After reading Tim Bray's analysis, Steve Jones presents his.
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor BCA KCU BANGKALAN Telp:0817629933
WhatsApp:0817629933 Jl. Trunojoyo No.15 A, Pejagan, Kec. Bangkalan, Kabupaten Bangkalan, Jawa Timur 69112
Alamat kantor BCA KCU HR MUHAMMAD Telp:0817629933
WhatsApp:0817629933 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa Timur 60189
BCA KCU BLOK A CIPETE HUB.Tlpn.0821•3111•185
BCA KCU BLOK A CIPETE HUB.Tlpn.0821•3111•185 Jl. RS. Fatmawati Raya No.6 A, RT.1/RW.5, Cipete...
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