Trusting Source Control
One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps a DBA track down a problem.
2015-06-30
5,110 reads
Articles
Grant User Access to All SQL Server Databases
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?
2015-06-30
5,795 reads
Learning about Multiple Tempdb Files
References and links to help you learn how to create multiple tempdb files.
2015-06-29
3,064 reads
Learning about the Cardinality Estimator
A few links to help you understand the Cardinality Estimator.
2015-06-29
319 reads
Learning SQL Server 2014
A list of technologies in SQL Server 2014 that you might want to learn more about.
2015-06-29
1,646 reads
Free Webinar: Can you Automate your Ops Away?
Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!
2015-06-29 (first published: 2015-06-26)
4,173 reads
Using a Recursive CTE to Generate a List
Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.
2015-06-26 (first published: 2013-07-09)
31,197 reads
Getting Started with Power BI Designer
The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.
2015-06-26
4,360 reads
Integration Services, MySql and SET FMTONLY ON
Challenges with integrating MySQL data in an ETL regime and the Amazing FMTONLY trick!
2015-06-25
3,795 reads
Learning SQL Server 2012
A collection of technologies and links that will help you learn more about SQL Server 2012.
2015-06-25
1,401 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers