(Tim Smith) One aspect of SQL Server database administration is monitoring and handling database growth. In this tip we look at how you can monitor SQL Server database growth against expected growth using PowerShell.
Tag: sql server
T-SQL – How to find Next Business day from a given date
(Prashanth Jayaram) There are many methods to find next business day. One common way is to use of calendar table. This post is to get an output using T-SQL Or UDF function.
Using SQL Server’s GROUP BY clause to Summarize your Data
(Gregory Larsen) There are times when you want to have SQL Server return an aggregated result set, instead of a detailed result set. SQL Server has the GROUP BY clause that provides you a way to aggregate your SQL Server data.
Discrete and Continuous data in SQL
(Joe Celko) Not all data is discrete; some data types represent a continuum. In SQL, we have to approximate them and live with the special problems of handling continuous data. We need to understand the problems associated with continuous data types, when these will happen, and how it affects constr
SQL SERVER – What is is_not_trusted in sys.foreign_keys?
(Pinal Dave) My greatest source of learning is via my blog. Many of you take time in asking your toughest questions and sometimes basic questions that make me think. This interaction creates a source of exploration for me and ultimately translates into my knowledge sharing.
Azure SQL Database Gets Closer to Pure SQL Server
(David Ramel) Microsoft announced a bevy of improvements to its cloud-based data products, including the Azure SQL Database Update V12 (preview), sporting new security features and bringing it closer to full SQL Server engine compatibility.
Explaining The SQL Server 2014 Analysis Services Data Mining Model Lift Chart
(Dallas Snider) How do I interpret the Lift Chart found on the Mining Accuracy tab of a SQL Server 2014 Analysis Services Data Mining structure?
Checking SQL Server Database Backups When You Don’t Have Access
(Bernard Black) Due to HIPAA, (I work for a hospital) a vendor who has installed SQL Server along with an application on a hospital system, will not give you a login to the SQL Server. “It is mandated by HIPAA”, he asserts. He further states “Only we and our application can connect to the database”.
SQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons
(Pinal Dave) Earlier I demonstrated a very interesting behavior in my blog post – UNION and UNION ALL with TEXT DataType – Observation, where we see that UNION clause with TEXT datatype returns Error but with UNION ALL it does not return an error.
Understanding SQL Server on Windows Azure VS Azure SQL database
(Vinoth N Manoharan) Often people get confused with the two different types of SQL Server service available on Azure or Microsoft cloud services,