SQL

Botched SQL Server 16 SP2 CU Sneaks Through and Microsoft Recommends Uninstalling

UPDATE: Microsoft has now released a fixed update for this issue: Security Update for SQL Server 2016 SP2 CU (KB4458621) Original article… Microsoft has already suggested one update from this month should be uninstalled – now here’s another. In a blog post announcement, the company says… On Tuesday August 14, we published a Security Update for six different releases of SQL Server 2016 and 2017. For one of those releases, SQL Server 16 SP2 CU (KB4293807), we inadvertently published additional undocumented trace flags that are normally not on by default. We are working on replacing the update in the next few days. If you installed KB4293807 and are experiencing issues please uninstall the update until the replacement update (KB4458621) is available.   Looking for...

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!

Using SQL Server on Linux for the Tachyon Databases

Sponsored A guide to using SQL Server on Linux for the Tachyon databases. After installation of SQL Server, then what? How can you integrate Tachyon? This guide will help. Why Would I Try This Out? First of all, let’s emphasize that running the Tachyon databases on Linux is not supported by 1E. However, “not supported” doesn’t mean “it won’t work.” Rather, it means “don’t call us if it doesn’t work.” When I found out that Microsoft had released SQL Server on Linux I thought that it would be a valuable experience to spend a small amount of time trying it out, mainly to satisfy my curiosity about how well it would work and how easy or difficult it would be. Installing SQL Server on Linux The documentation pages (https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup) describ...

Avoid Installing WID and SQL on the Same Server

By Garth Jones Recently I built a new test lab. As an aside, in my opinion, this is one of the most complicated labs that you could have, but I’ll write more about that at a later date. While building this lab, I needed to setup WSUS on my new CAS server. Usually, when you setup the WSUS server role on the server, there is a post role task that needs to be completed before WSUS can be used. Normally you click the post task in Server Manager and a few minutes later the task gets marked as successfully completed. Needless-to-say, the post task didn’t complete successfully for me. When I reviewed the log file, I saw the following error message: You can clearly see within the error message (highlighted text) that it looks like there was an error within the database (DB) structure. When I resea...

Introducing SQL Server on Linux

Lead engineer, Travis Wright demonstrates SQL Server on Linux, including how you can: download and install SQL Server on a Linux Virtual Machine; run your SQL Server-based apps inside of Docker containers and improve the performance of your applications using powerful features such as Column Store in SQL Server. Looking for an awesome, no-nonsense technical conference for IT Pros, Devs, and DevOps? IT/Dev Connections kicks off in San Francisco in 2017!

Microsoft Adds Advanced Features Across All SQL 2016 Editions with Service Pack 1

On Wednesday, Microsoft announced the first service pack for SQL Server 2016. Any service pack is big news for customers, but this particular service pack delivers some additional functionality across all editions of SQL Server 2016 that many customers were not expecting. By applying SQL Server 2016 Service Pack 1, Advanced features will become available across all SQL Server 2016 editions. From Standard to Enterprise, all SQL Server 2016 editions will take advantage of the following advanced features: Always Encrypted Change Data Capture ) Columnstore indexes Data Compression Database Snapshots Dynamic Data Masking) Fine Grained Auditing In-Memory OLTP) Multiple FILESTREAM Containers Partitioning Polybase Row Level Security) Why the change? Per Microsoft… Microsoft is making it easi...

SQL Server v.Next for Windows and Linux CTP Available for Evaluation

Among a slew of announcements during today’s Connect event, Microsoft has announced that SQL Server v.Next for Windows and Linux is now available to download to evaluate as a Community Technology Preview. The product was previously only available through an invite. The bits are now available for download form the Microsoft Evaluation Center here: https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-vnext-ctp SQL Server v.Next includes the following: Enhanced support for R Services Improved machine learning capabilities Deep neural networking features Standard SQL management tools for Linux Encryption and row-level security for Linux In-memory column stores for Linux Looking for an awesome, no-nonsense technical conference for IT Pros, Devs, and DevOps? IT/Dev Connections ki...

Collection Evaluation Viewer and Certificate Chain

By Garth Jones While I was writing my blog posts, ConfigMgr Collections and Collection Evaluation Viewer and How to Fix a Poorly Written WQL Query, I ran across an interesting issue when trying to remotely connect to my primary site. At first I didn’t notice the error message but after a few seconds I saw it at the bottom (red arrow) of Collection Evaluation Viewer (CEV).* The error states, “A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority….” What is this error about? The error occurs when you are running CEV remotely from your ConfigMgr site server and you don’t have the ConfigMgr SQL certificate installed on your local PC. How do you fix this...

Query Formatting Tools

By Garth Jones As many of you know I answer a lot of ConfigMgr query-related questions. One of my pet peeves is seeing poorly formatted queries because they are difficult to read! For example, take this unformatted WQL query. What is it doing? When I see queries similar to this one, I usually do one of the following: · Manually format the query, so that I can read it. · Scan the query to try and pick out the important parts. · Skip the question entirely. When I have time to manually format the query I’ll come back to it, but unfortunately, that could be months from when the question was first posted. Recently I learned from Mickey Stuewe @SQLMickey about online tools that will format a query for you. What a great idea! After a quick search, I found Redgate’s @redgate online tool, but after...

SQL 2005 Report Giveaway!

Last week we told you that SQL Server 2005 is no longer supported by Microsoft. What does this mean to you? Well, if you are using ConfigMgr 2007 you’ll need to upgrade to SQL Server 2008. In order to help give you a better handle on the amount of SQL 2005 software in your organization, we’re giving away copies of our Count of SQL 2005 Editions report! Simply send an email requesting this report to Info AT Enhansoft. This SSRS report will provide you with a count of all of the SQL 2005 editions within your environment. You can read Garth Jones’ blog post, Goodbye SQL 2005! in its entirety on our blog site.

Goodbye SQL 2005!

By Garth Jones April 12, 2016 marks the end-of-life for SQL Server 2005. What does this mean to a ConfigMgr administrator? You need to upgrade to at least SQL Server 2008 if you are still running Microsoft System Center Configuration Manager 2007, otherwise 2005 won’t be supported. If you are running System Center 2012 Configuration Manager or higher you don’t need to worry as the minimum SQL server version is 2008. By the way, the end date for the 2008 version of SQL is July 9, 2019. What does end-of-life for SQL Server 2005 mean for Enhansoft? It means that starting today we no longer support SQL 2005 with any of our products. More importantly, it allows us to start using all of SQL Server 2008’s features and functions! I’m truly excited about this move and can tell you that our team is ...

ConfigMgr: Identifying Win10 Credential Guard Hardware Requirements

HP-InstrumentedBIOS  – OMCI_SMS_DEF – TPM Using Microsoft Windows 10 (Enterprise), organizations can now take advantage of a new technology called Credential Guard, which isolates certain types of sensitive data so that only privileged system software can access it. As a result, credential theft attacks (Pass-the-Hash, Pass-The-Ticket, etc.) are prevented by protecting NTLM password hashes and Kerberos Ticket Granting Tickets. While Credential Guard is an effective way to protect against these types of attacks, it comes with a set of specific hardware requirements that must be met in order to implement this new technology. The sections below describe just one scenario for how to use System Center Configuration Manager (2012 or current branch) to identify which systems support/d...

  • 1
  • 2
  • 5