Lessons Learned Pay Off
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
SQLServerCentral Best Practices Clinic: Part 4
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
Using SQL Server to collect information from your Oracle server
Using linked connections you can collect system information on your Oracle server from SQL server.
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile.
A Live Node
Today we have an editorial from March 29, 006 as Steve is on vacation. Today Steve talks about the problems of constantly being distracted and not focusing on one thing.
Advice from Exceptional DBAs: Do it!
Nominations for the Exceptional DBA of 2011 opened on May 25. Bob Cramblitt spoke with past award winners to find out what has happened to them since receiving the award and to get advice for people thinking about nominating themselves or colleagues.
SQL Server Agent Jobs without an Operator
I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.
A Note to My Fellow Application Developers about Knowing Our Limits
Today we have a guest editorial from Chris O’Connor as Steve is on vacation. Today Chris talks about the responsibilities of application developers in safeguarding the data when there is no DBA.
Can't Connect Remotely to Integration Services
Integration Service is running on rnage of dynamic port and user can’t connect Integration Service remotely.
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
Berikut cara menutup kartu kredit UOB sampai tuntas
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
Ini tata cara mudah menutup - menonaktifkan kartu kredit UOB
Untuk menonaktifkan dan menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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