SQL create database automation | ApexSQL
Schedule Backup in SQL Server 2008, schedule backup in sql server, schedule backup in sql server 2012
SQL create database automation | ApexSQL
This topic describes how to rename SQL Server database using SQL Server Management Studio(GUI), Transact-SQL(command line) and detach/attach method
I will design and develop your database schema and write sql - Databases. Click on the link for see the service on Fiverr.
sql error 26, sql server error 26, sql server error 26 client unable to establish connection, error 26, error 26 error locating server
sql error 26, sql server error 26, sql server error 26 client unable to establish connection, error 26, error 26 error locating server
SQL Для Начинающих (Часть 2)
How to take an SQL Server database offline? Simple methods to bring a MSSQL database to offline state using transact-SQL or management studio.
Webinar: Delivering Microsoft SQL Server High Availability on AWS You can use AWS services like Amazon EC2 and Amazon RDS to quickly build, deploy, scale and manage your SQL Server databases, which helps you build more agile applications. This webinar covers best practices for running SQL Server business-critical applications on AWS. Zlatan Dzinic, of AWS, and Dave […]
Finding the deadlocks and blocked processes using extended events In SQL Server. Collecting deadlocks using extended events
Simple method to detach and attach database in SQL Server. T-SQL method and SSMS method to detach an database and attach it back.
Using simple sql technique, here we will see how to get the list of temporal tables in a database.
A blog about Java, Programming, Algorithms, Data Structure, SQL, Linux, Database, Interview questions, and my personal experience.
could not open a connection to SQL Server, error: 40, a network-related or instance-specific error, Named Pipes Provider
I recently talked with the guys over at SQL Data Partners on their podcast about SQL Server and containers. It was real good fun and I enjoyed chatting with Carlos Chacon (b|t) and Steve Stedman (b|t)about container technology and my experiences with it so far. Would definitely like to go back on (if they'll have…
SQL Server on Linux has been out for a bit now and I've played around a little (see here) but haven't really used it in "anger" nor will I for the foreseeable future if I'm honest. Nevertheless it's an area that I find very interesting as I know very little when it comes to the…
No, this isn’t one of those “why my RDBMS is better than your RDBMS” comparisons. One of the initial stumbling blocks a DBA on one system e...
How to generate row number without using ORDER By clause in SQL Server. Simple technique to override the sequence ordering while using ROW_NUMEBR() function