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
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers