Data Engineering – Learn from the experts
-
DATETIMEFROMPARTS function – SQL Server Denali
This function is new to SQL Server denali to return datetime value from the input given. This function is similar to DATETIME2FROMPARTS however here we don’t have fractions and precision argument instead we have milliseconds argument here. If the arguments are not valid then an error is raised or if the argument is NULL then…
-
DATETIME2FROMPARTS function – SQL Server Denali
We have one more new date time function in Denali. DATETIME2FROMPARTS is the function name which is used to returns datetime2 value for the input value given. If the arguments are not valid then an error is raised or if the argument is NULL then it will return a NULL value. This function is to…
-
Startup procedure to check SQL Server status when restarted
I’ve written a startup procedure to check SQL Server status when the SQL Server gets restarted. Most of the time as a DBA when a Server gets rebooted or SQL Services is restarted we need to make sure everything is fine in SQL server to make sure SQL server is running healthy. Some companies will…
-
Deploying Data Tier Application (DAC) Package
Last week I wrote an article for Creating DAC packages. Today I’m going to cover how to deploy a DAC package. It’s very easy for the DBA’s to deploy the DAC in few clicks that means in few clicks database implementation will get completed, it’s as simple as like that. I’m going to use the…
-
Creating a Data Tier Application (DAC) Package
In previously article I’ve covered what is DAC package and how it helps during deployment. In this article I’m going we are going to see how can we create a new data tier application (DAC) package for deployment. All SQL Server related objects can be included in this package for deployment, this includes both database…
Got any recommendations?