Category: Microsoft SQL Server

Feed: Liquid Web. Author: Liquid Web; You might not realize it, but databases are everywhere. Whether or not you know very much about them, their effect on our daily lives is extensive. From weather applications to the movies you watch online, databases are responsible for many of the services we utilize daily.We have collected a few of the more well-known examples of how databases enhance your day-to-day life below. The most popular database server in our industry, MySQL, is prevalent in virtually every example listed below. Like this content? Subscribe now and have more just like it sent straight to your ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . On September 24th Microsoft released the first Community Technical Preview for SQL Server 2019, which was CTP2.0. At the same time Microsoft pushed out a new preview for SQL Server Management Studio (SSMS) known as version 18. Remember, Microsoft now provides a separate download for SQL Server Management Studio. It is no longer provided with SQL Server. You can download this new SSMS preview at https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms?view=sql-server-2017#ssms-180-preview-4download-sql-server-management-studio-ssmsmd This new version of SSMS has a smaller download size, and it no longer shares components with the database engine. By not sharing components, Microsoft has ... Read More

Feed: Blog. Author: Jon12; We have heard a number of our DBA customers ask for reporting of SQL Inventory Manager data for a number of reasons - (be able to provide executive reporting, determine the state of environment and make better informed decisions about the SQL servers in their environment...).   So in SQL Inventory Manager 2.4, we have added the ability to get additional reporting on your inventory data with four reports: SQL Licensing report - extends the MS SQL Licensing reports available in the main Inventory Manager application by adding fields like custom inventory fields and tags. Inventory report ... Read More

Feed: Databasejournal.com - Feature Database Articles. Author: . At the PASS Summit in Seattle, Microsoft announced the release of the CTP 2.1 for SQL Server 2019.  This is the second community technology preview released for SQL Server 2019. Here is a list of the new features included in this new CTP version: Deploy and manage R and Python scripts as an application inside a SQL Server 2019 big data cluster Improves Intelligent query processing by adding scaler UDF inlining Improves truncation error messages by include table and column names, as well as truncated value Adds support for UTF-8 collations to ... Read More

Feed: Blog. Author: johncole; Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day. The backup process is so essential that it usually requires distinct processes, checklists, and multiple database administrators to perform, and manage. Still, backup errors are among the most common, time-consuming, and costly problems administrators face on a regular basis. Realizing a backup has failed after it is too late is one of the worst feelings any database administrator could experience. Backup mistakes are often costly, always time-consuming, and can even cost database administrators ... Read More

Feed: James Serra's Blog. Author: James Serra. With data lakes becoming very popular, a common question I have been hearing often from customers is, “Should I load structured/relational data into my data lake?”.  I talked about this a while back in my blog post What is a data lake? and will expand on it in this blog.  Melissa Coates also talked about this recently, and I used her graphic below to illustrate: I would not say it’s common place to load structured data into the data lake, but I do see it frequently. In most cases it is not necessary to first ... Read More

Feed: Blog. Author: SQLWareWolf; In the previous post, we went over the details of DBCC_SHOW_STATISTICS, now let’s see how this comes together.  We shall run the histogram for the ProductID from the Sales.SalesOrderDetail table.         DBCC    SHOW_STATISTICS('Sales.SalesOrderDetail', IX_SalesOrderDetail_ProductID)  WITH HISTOGRAM ;         -- Review the section for range 826 - 831         GO Pay attention to the Range_HI_Key of 831.   The Avg_Range_Rows are 36 2/3. Now let’s run a query to see how SQL Server uses these statistics to create an execution plan. 1 2 3 4 5 6         SELECT  productID               ,         Count(1) as Total         FROM    Sales.SalesOrderDetail         WHERE   ProductID BETWEEN 827 and 831         GROUP   BY ProductID            ;         GO ... Read More

Feed: Blog. Author: Joy Ruff; As many companies are coming to realize, the General Data Protection Regulation (GDPR) issued by the EU, which takes effect in May 2018, has a lot of stipulations and guidelines. It is definitely a team effort to follow all the rules and ensure compliance to the plethora of requirements. Many of these directives align with other regulations such as HIPAA and Basel, with regards to knowing what data you have, which data is sensitive, and who is accessing it. GDPR takes it a step further with additional personal protections and significant penalties for non-compliance.IDERA recognizes ... Read More

Feed: Blog. Author: Jim Donahoe; So in Part 1 of this series, we created and configured our Failover Group. Well, now that the easy stuff is out of the way, let’s talk about how you connect to these groups via SSMS.  This is where some of the confusion happens.  When I first configured a Failover Group, the first thing I tried to do was connect to the Primary server via SSMS thinking it will work just like an Always On Listener in traditional SQL Server…NEWP!  I got this lovely error when I tried: But, I know my username and password is correct ... Read More

Feed: Blog. Author: Jim Donahoe; Hey everybody!I am asked by clients/team members/friends a lot about how to setup TEMPDB to use the D: drive on an Azure VM for SQL Server.  Following the steps listed below is how I configure it on my VM’s. This seems to be the most standard way folks are doing it.  However, this is not always the best practice to do.  The reason being is that the drive size varies depending on the VM size you choose. Read the section “Temporary Disk” first, then decide on where to place your TempDB. Temporary disk – AKA ... Read More