2015-11-04
4,023 reads
Articles
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.
2015-11-04
5,092 reads
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.
2015-11-03
2,967 reads
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.
2015-11-03
2,813 reads
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.
2015-11-03 (first published: 2015-10-13)
8,620 reads
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.
2015-11-02
3,769 reads
10 New Features Worth Exploring in SQL Server 2016
Greg Larson gives an in-depth look at ten of the new features you can expect from SQL Server 2016.
2015-10-30
8,121 reads
Top 10 Most Common Database Scripts
What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite the range of tasks we do, there are some common tools we use.
2015-10-29
9,303 reads
SQL Prompt Tips #3 - Snippet Placeholder $Paste$
Another quick tip for SQL Prompt, using the snippets to increase your productivity.
2015-10-28 (first published: 2012-05-01)
1,488 reads
Using Power BI in a Hybrid Environment
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
2015-10-28
2,633 reads
Blogs
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
By gbargsley
Have you ever received the dreaded error from SQL Server that the TempDB log...
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
By Chris Yates
Artificial intelligence is no longer a distant concept. It is here, embedded in the...
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers