Category: Microsoft SQL Server

Feed: James Serra's Blog. Author: James Serra. There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand.  I wanted to list the big data related presentations that I found the most useful.  It’s a lot of stuff to watch and with our busy schedules can be quite challenging to view them all.  What I do is set aside 40 minutes every day to watch half a session (they are 75 minutes).  If may take a few weeks, but if you consistently watch you will be rewarded by a much better understanding of all the ... Read More

Feed: SQL Server Customer Advisory Team. Author: Arvind Shyamsundar. Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Rajesh Setlem, Joe Sack, Dimitri Furman, Denzil Ribeiro (Microsoft) This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions. SQLCAT has been working with them in their process of adopting SQL Server 2017. During a recent lab engagement, we found a set of seemingly innocuous query (anti-)patterns which were actually having a significant impact on overall performance. In ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. This post was authored by Alan Yu, Program Manager, Microsoft SQL Server We are excited to announce the release of SQL Server Management Studio (SSMS) 17.3! Download SSMS 17.3 and review the Release Notes to get started. SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available. In addition to enhancements and bug fixes, SSMS 17.3 comes with two new exciting features: Import Flat File Wizard XEvent Profiler Import Flat File Wizard The Import Flat File Wizard streamlines ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. IT pros now have the flexibility of running workloads across Windows, Linux, or a combination of both. By taking advantage of SQL Server 2017 on Linux, you’ll get enterprise-grade features at open-source pricing — all backed by Microsoft support and security. It’s never been easier or more cost effective to make the move. SQL Server 2017 combines the best of databases and analytics into one product. New enhancements include real-time intelligence due to faster transactions with In-Memory OLTP, new T-SQL enhancements for in-memory tables and natively compiled stored procedures, ColumnStore performance improvements, ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . Don’t you just love getting that email with the subject: “The application is slow! Please check the database!”?  You’re then expected to very quickly figure out what’s behind the slowdown – usually with zero context information – and, if it is a database issue, get it running at full throttle again ASAP. If the users only knew what checking the database entails in this situation.  With so many causes and solutions to go through, you might expect to be spending the night at work, instead of in your warm bed.  (Sadly, I’ve ... Read More

Feed: Blogs – Simple Talk. Author: Dennes Torres. SSMS has an interesting feature that turns easy the creation of policies to check our servers compliance. Right-clicking an item inside object explorer window, you will find ‘Facet’ item in the context menu. Clicking on it will open the ‘View Facets’ window. In the ‘View Facets’ window, you can see all the facets related to the object you right-clicked. For example, the database object has a total of 5 facets. Creating a new policy Let’s use this feature to create a new policy: Click the ‘Facet’ dropdown list in the ‘View Facets’ ... Read More

Feed: SQL Server Customer Advisory Team. Author: Kun Cheng (SQLCAT). Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem Most people familiar with Azure SQL DB (aka SQL Database) are aware of the firewall setting requirements of SQL DB, which are very important to lock down connections to SQL DB on Azure. Details are documented here. The firewall setting helps restrict inbound connections to clients with specific IP addresses. Note that this refers to the firewall on the Azure SQL DB side. But when the SQL client is running on-premises behind internet gateway/proxy server, the firewall of the gateway/proxy ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. We are happy to announce SQL Server 2017+ Management Pack Release Candidate with new features is ready (6.7.65.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). NEW: Version Agnostic SQL Server MPs We understand that with many SQL Server versions in market and with new server releases becoming more frequent, it is becoming harder to manage a separate MP for each server version. We are moving to version agnostic MPs to address this issue. This will be valid going forward. The new MP is named SQL Server ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. SQL Server Product Team is excited to bring you the final release of SQL Server 2012 Service Packs, Service Pack 4 (SP4). This release of SQL 2012 Service Pack has 20+ improvements centered around performance, scalability and diagnostics based on feedback from customers and the SQL Server community. These improvements enable SQL Server 2012 to perform faster and scale out of the box on modern hardware design. In addition to improvements listed below, SQL Server 2012 SP4 includes all the fixes up to and including SQL Server 2012 SP3 CU10. Following ... Read More

Feed: SQL Server Blog. Author: SQL Server Team. The SQL Server team is excited to bring you the final service pack release for SQL Server 2012. The service pack is now available for download on the Microsoft Download Center and will be coming soon to Visual Studio Subscriptions, MBS/Partner Source, and VLSC. As part of our commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2012 deployments. SQL Server 2012 Service Pack 4 (SP4) contains a roll-up of released hotfixes as well as more than twenty improvements centered around performance, scalability, ... Read More