SQL Prompt Tips #4 - System Objects
A quick tip to help you get system object suggestions from SQL Prompt.
SQL Server Reporting Services General Best Practices
Ghanesh Prasad discusses 12 best practices any developer or DBA should follow when working on a SSRS project.
Hello Azure: Azure IaaS - Getting Started
A new series to take you through the basics of how to get started using Azure as your own personal lab.
Virtual Failback
The pressure to move to virtual systems is increasing, but is there a fallback if you have issues?
So You Need to Expose JSON Endpoints
Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.
Webinar: Database version control - optional or required?
Join Justin Dearing and Elizabeth Ayer to hear about some of the key challenges of database version control, and why it's only a matter of time before it's as essential as good backups and high performance.
Secret Software Security
The move to limit disclosure of vulnerabilities continues, with potential issues for many of us.
SQL Injection - The Revenge
As yet more personal details are spilled by preventable security lapses, what's
A Skills Roadmap for DBAs in the Cloud Era
Cloud computing is on the move. Slowly but surely, businesses are transitioning more and more key pieces of infrastructure to the cloud in order to take advantage of cost, flexibility and agility benefits. And databases, the heart and soul of all applications, are the most critical component of this transition. Gerardo Dada explores the topic.
Blogs
T-SQL Tuesday #198 Roundup: How Do You Detect Data Changes?
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Optimizing Redshift Performance by Configuring WLM Queues
Efficient query performance in Amazon Redshift often comes down to how well you manage...
PowerShell Strikes Back: Return of the Loop
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers