Loginless Database Users and Dynamic SQL
Implement Loginless Database Users to maintain data security and preserve interface when dynamic SQL is being used within a stored procedure.
What does certification achieve?
Part 2 of a set of thoughts from Steve Jones on certification in technology areas.
A Variety of Tracks at DevConnections
It's less than a month until DevConnections in Las Vegas. With tracks that cover SQL Server, Windows, Exchange, SharePoint, Dev and more, this is a great place to learn about a variety of technologies. Register today
Compare Big Data Platforms vs SQL Server
SQL is derided by modern developers as 'Scarcely Qualifies as a Language'. But just how efficient are the new wave of NoSQL languages touted by bleeding-edge skunk works? This tip is a defense of SQL and of the relational model, and argues for the efficiency and suitability of relational technology. Check out this tip to learn more.
No More MCM
With the discontinuing of the MCM And MCA programs, Steve Jones has a few thoughts. This is the first of a three part series on certifications.
The Loss of Trust
The news about NSA spying keeps coming out, and apparently includes corporate communications as well.
SQL Saturday #250 Pittsburgh
September 14, 2013 Pittsburgh will be hosting a SQL Saturday. Join them for a free day of SQL Server training and networking. There will also be a paid pre-con session the day before on Performance Tuning in SQL Server 2012 presented by John Sterrett and Konstantin Melamud.
Using DAX to create SSRS reports: The Basics
You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.
Developer Pressure
As we ask developers to deliver software quicker, are we helping improve the quality of software? Steve Jones asks the question today.
SQL Server Error Log Scanning
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
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