in any database management system, security and security are always top priority. and with sql server, if we take advantage of the many advantages of this application, those who
sql server 2008 sp2 also updates for reporting and management tools, supporting up to 15,000 database (partition) partitions.
one of the most important things you must do in sql server 2008 is to install data and log files
in this article, we use the linux operating system ojuba 2 - 1 based on fedora 10 framework framework, the account used here is root
there are many different requirements for sql server 2008 that must be met, depending on the version of sql server you are installing and the operating system platform you are
in the previous section we explored some of the improvements in sql server 2008 t-sql statements, including intellisense, grouping set, and forceseek hint tables.
sql server 2008 integrates many remarkable new features. one of these features is improvements in t-sql statements that reduce the time spent working on these statements.
transaction log (also known as database log or binary log) is an action history that is executed by the database system to ensure acid properties when the system fails.
this article will illustrate the different usage methods of the 'for attach' clause to overcome the limitations encountered when using sp_attach_db and sp_attach_single_file_db.
in this section, i will show you how to get that information in top 10 queries based on cpu performance.
instead of using vbscript, bat files, or sql client implementations, ... we'll show you the power of windows powershell in checking sql servers status.
this part 2 will show you how to access the windows service on the remote computer using windows powershell and wmi-object.
in part 3, i will show you how to find some hardware and operating system information from the host machine.
in this next section, i will show you the information about network card and hard drive from the server.
in this part 5, we will check whether we can connect to sql server and see if we can query some properties related to sql server.
part 6 will show you how to check all existing databases in the sql server instance and query the database properties.
in sql server, the case function verifies the value based on the list of given conditions, then returns one or more results. in this article we will illustrate a number of
the following 5 reasons will make you want to upgrade to sql server 2016 without hesitation.
at the pass summit 2017 conference yesterday, microsoft announced several new improvements to sql server 2017 and azure data services.
sql server 2008 and 2008 r2 will stop supporting on july 9, 2019. windows server 2008 and 2008 r2 will stop supporting on january 14, 2020.