SQL Server

Microsoft Updates Tool to Troubleshoot Kerberos-related Connectivity Issues with SQL Server

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services, and SQL Server Analysis Services. It can perform the following functions: Gather information on OS, Microsoft SQL Server instances and Always On Availability Group Listeners installed on a server. Report on all SPN and delegation configurations on the server. Identify potential problems in SPNs and delegations. Fix potential SPN problems.   Download: Microsoft Kerberos Configuration Manager for SQL Server This release (v4.1) adds support for Always On Availability Group Listeners, and fixes SPN format incompatibility with Windows Server 2008 and 2008 R2 (introduced in v4.0). Looking for an awesome, no-nonsen...

Amazon RDS Adds Support for SQL Server 2017 and SQL Server 2016 SP1 CU5

Amazon has now announced added support for running SQL Server 2017 and SQL Server 2016 SP1 CU5 instances for its Amazon RDS service. Amazon RDS for SQL Server now supports Microsoft SQL Server 2017 and SQL Server 2016 SP1 CU5 for Express, Web, Standard and Enterprise Editions on the Windows Operating Systems. You can now leverage SQL Server 2017 features such as GraphDB, Automatic Plan Correction, and Resumable Index Rebuilds on your Amazon RDS SQL Server Instances. Amazon RDS for SQL Server 2017 and 2016 SP1 CU5 can be deployed using the licenses you currently own, with the ‘Bring Your Own License’ option or by paying for licenses by the hour with the ‘License Included’ option. Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and sc...

Microsoft Announces SQL Operations Studio Public Preview 1

SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. SQL Operations Studio on GitHub: https://github.com/Microsoft/sqlopsstudio Features: Cross-Platform DB management for Windows, macOS and Linux with simple XCopy deployment SQL Server Connection Management with Connection Dialog, Server Groups, and Registered Servers Object Explorer supporting schema browsing and contextual command execution T-SQL Query Editor with advanced coding features such as autosuggestions, error diagnostics, tooltips, formatting and peek definition Query Results Viewer with advanced data grid supporting large result sets, export to JSON\CSV\Excel, query plan and charting Management Dashboard supporting customizable widgets ...

Ask The Experts at #ITDevConnections – Data Platform and Business Intelligence Track

Extremely valuable, our Ask the Experts sessions were streamed over Facebook Live at IT/Dev Connections 2017. Here’s the full recording for the Ask The Experts at #ITDevConnections – Data Platform and Business Intelligence Track.   Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in Dallas, Texas in 2018!

How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?

By Garth Jones I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?” In order to update the RDLs I would have to perform a, “Save As,” or edit each report. In the closing section of that post, I complained that with over 600 reports, I needed to find a way to bulk upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2. It took a little time and research, but in the end I stumbled upon a way that may not be completely automatic, but it’s still a great time saver! This blog post will show you how to bulk upgrade SSRS RDLs. The Problem Let me begin by reminding you about the problem that I had with the, “Unknown Report Version 9.0,” error m...

What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?

By Garth Jones A long time ago I started working on two projects using SQL Server Business Intelligence Development Studio 2005 (BIDS). I wanted to keep working on these projects, so I upgraded from BIDS 2005 to SQL Server Data Tools Visual Studio 2015 (SSDT). After editing and then trying to save one of the SQL Server Reporting Services (SSRS) reports in SSDT, I received this notification, “Unknown Report Version 9.0.” This blog post will tell you about the steps I took to troubleshoot this problem. Upgrading from Previous BIDS/SSDT Solutions to Latest Version of SSDT Notice that when you upgrade your solutions and projects, you are given a warning message that this is a one-way upgrade. As you may or may not know, when you import a solution and project from an older version of either BID...

How Do I Enable CLR within SQL Server?

By Garth Jones If you take a copy of your System Center Configuration Manager (SCCM) database and put it on your laptop (or anywhere else) without SQL Server common language runtime (CLR) enabled, you will receive an error when accessing Role-Based Administration (RBA) functions. The error message that you will receive will look similar to the one below. This blog post will talk about why and when this happens and how you can enable CLR within SQL Server. Msg 6263, Level 16, State 1, Line 6 Execution of user code in the .NET Framework is disabled. Enable “clr enabled” configuration option. Why Would You Put a Copy of Your SCCM Database on Your Laptop? During any of my presentations on either reporting for SQL Server Reporting Services (SSRS) or querying the SCCM database, I strongly advise...

How Do You Install SQL Server Data Tools?

By Garth Jones Many of my blog posts about tips and tricks for reporting (mostly SQL Server Reporting Services (SSRS)) focus on System Center Configuration Manager (SCCM). Recently I noticed, while writing another blog post, that I don’t have a post about how to install SQL Server Data Tools (SSDT). SSDT is the SSRS reporting tool component. Installing SSDT on your workstation will allow you to create projects for dashboards and reports. Let’s get started! Installing SQL Server Data Tools If you follow my blog or if you attend any of my presentations, you’ll know that I always recommend to install SSDT and SQL Server Management Studio (SSMS) locally on your computer. Doing so allows you to manage SQL Server and to create queries, dashboards, and reports all on your computer without tying u...

Does SQL Server Database Compatibility Level Matter?

By Garth Jones Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over six hours to complete! This didn’t make any sense to me especially when its “twin” query took only 25-seconds to complete. After a lot of troubleshooting, I began to wonder, “Does the SQL Server database compatibility level matter?” This blog post will describe the problem, how I eventually discovered the solution and finally was able to reduce the query’s time down to 29-seconds! Background I created an Asset Intelligence (AI) dashboard report set and it worked perfectly in my small lab of 40+ computers. When I tested the same dashboard, however, in a 20,000+ computer environment, it kept timing out after about 30 minut...

Why is Using a SQL Server Alias for Column Names Important?

By Garth Jones Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.” Within the detailed part of the error message it said, “An item with the same key has already been added.” This happened when I pasted my working query from SQL Server Management Studio (SSMS) into Visual Studio 2015 – Business Intelligence also known as SSDT-BI. This blog post will discuss this error and why using a SQL Server alias for column names is important when solving this problem. How could I be getting this error message when the query worked perfectly in SSMS? Troubleshooting the Error Message Trying to solve this issue I copied the query, again, to SSDT-BI. I closed and reopened SSDT...

Microsoft Announces SQL-focused Security Engine

At Microsoft Ignite today, the company has announced a new security mechanism solely focused on securing SQL Server data and workloads. SQL Vulnerability Assessment seeks to discover, track, and remediate potential database vulnerabilities and works for Azure SQL Database and for on-premises SQL Server. The scan is lightweight and safe, takes a few seconds to run, and is entirely read-only. See the SQL Vulnerability Assessment docs for full information.   Looking for an awesome, no-nonsense technical conference for IT Pros, Developers, and DevOps? IT/Dev Connections kicks off in San Francisco in 2017!

Cloud Reporting: How to Setup a Linked Server

By Garth Jones What about cloud reporting? What if your cloud provider doesn’t have the tools that you need to create reports from a database in the cloud? These were the questions on my mind when I was asked, “How can I get a daily report on an internal application?” Based on my discussions with IT professionals at conferences and online in forums, etc., reporting is still the number one item that people need and want. I don’t escape these reporting requests as I’m often asked by the Enhansoft team to create internal reports. This blog post will show you how I setup a linked SQL Server connection on one of my on-premises SQL Servers. This was done so that I could report on results from my cloud-hosted SQL Server database. Ultimately I created a SQL Server Reporting Services Report (SSRS) ...