Profile

Cover photo
Verified name
ApexSQL software
3,016 followers|1,091,185 views
AboutPostsPhotosYouTube

Stream

ApexSQL software

Shared publicly  - 
 
How to script SQL Server database users with roles
w/ Ahmad Yaseen

#SQLServer       #SQL  
Introduction A request is received from the development team asking to copy one of the production databases to the DEV SQL Server in order to simulate real time testing scenarios on it. Once the production database backup is restored to the DEV SQL instance, replacing the old copy, the old DEV database users will be …
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
In-Memory OLTP Series – Data Migration Guideline Process on SQL Server 2016  
w/ Luan Moreno M. Maciel

#SQLServer       #SQL  
On the last article about the best modes to move the disk-based tables to using the In-Memory feature we covered all the aspects and styles available on SQL Server 2014. Continuing on the migration process now we’re going to look at some of the new enhancements of makes SQL Server 2016 Data Collector [Transaction Performance …
2
Add a comment...

ApexSQL software

Shared publicly  - 
 
A DBAs introduction to Mercurial – Working with files and changes
w/ Joshua Feierman

#SQLServer       #SQL  
Introduction In my previous article, we went over the reasons why DBAs should use version control, as well as the benefits of Mercurial as a specific choice. We also gave three examples of instances where source control can come in handy (though to be honest they were picked from a much longer list). In this …
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
In-Memory OLTP Series – Data migration guideline process on SQL Server 2014  w/ Luan Moreno M. Maciel

#SQLServer       #SQL  
In this article we will review migration from disk-based tables to in-memory optimized tables. This article assumes that you already understand the pros and cons about In-Memory Technology, for more articles about this, please refer here. There are some options available on SQL Server 2014 and SQL Server 2016 that will help you to identity, …
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
ApexSQL Monitor vs the competition: Comparison matrix

goo.gl/TI3IoC

#SQLServer       #SQL  
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
Creating a stored procedure to fix orphaned database users
w/ Eli Leiba

goo.gl/fXY1sU

#SQLServer       #SQL  
1
Add a comment...
In their circles
47 people
Have them in circles
3,016 people
Lisa Hall's profile photo
The Definitive Guides To Google+'s profile photo
Stella Pollard's profile photo
Dred TV's profile photo
Tutorial Design's profile photo
Aleksandar Minic's profile photo
Sam Lukasa's profile photo
jitesh chauhan's profile photo
Ocean State Software's profile photo

ApexSQL software

Shared publicly  - 
 
What is causing database slowdowns?
w/ Kimberly Killian

#SQLServer       #SQL  
Why is my database so slow? This query used to be so much faster. Why does it take so long to rebuild my index? How come it was fine last month? Every day I am asked these types of questions by clients. Every day! A lot of database developers and application developers do not realize …
2
Add a comment...

ApexSQL software

Shared publicly  - 
 
How to run a local SQL Report from an Azure VM Database
w/ Daniel Calbimonte

#SQLServer       #SQL  
Introduction In this new article, we will create a SQL Server Report using SQL Server Reporting Services from a SQL Server machine installed in an Azure Virtual Machine. We will show step by step how to connect from a local machine to a VM Azure Database and generate a SQL report. Figure 0. Creating a …
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
Database snapshot in SQL Server
w/ Rajendra Gupta

#SQLServer       #SQL  
Database snapshot is a great feature that offers virtual read only consistent database copy. When we create the database snapshot in the live operational database, it takes a database point in time static view and Rollback all uncommitted transactions in the snapshot database so we will not be having any inconsistent data that is yet …
1
Add a comment...

ApexSQL software

Shared publicly  - 
 
Win a free trip to SQL PASS Summit 2016 in our SQLShack 2016 author contest

goo.gl/ayij8f

#SQLServer       #SQL  
2
Add a comment...

ApexSQL software

Shared publicly  - 
 
How to format all SQL objects in your database

#SQLServer       #SQL  
The Format SQL objects feature allow formatting one or more database objects with the specified formatting profile, without having to script them first. There are three ways to invoke the Format SQL objects feature. First, you need to select a database from which you want to format objects. Otherwise, when you try to initiate the …
2
Add a comment...

ApexSQL software

Shared publicly  - 
 
Understanding the distribution scale of transactional and snapshot replication  w/ Timothy Smith

#SQLServer       #SQL  
1
Add a comment...
People
In their circles
47 people
Have them in circles
3,016 people
Lisa Hall's profile photo
The Definitive Guides To Google+'s profile photo
Stella Pollard's profile photo
Dred TV's profile photo
Tutorial Design's profile photo
Aleksandar Minic's profile photo
Sam Lukasa's profile photo
jitesh chauhan's profile photo
Ocean State Software's profile photo
Contact Information
Contact info
Phone
+1 (866) 665-5500
Email
Address
2501 Blue Ridge Road (Atrium building) #250, Raleigh, North Carolina
Story
Tagline
Killer tools for SQL Server
Introduction
ApexSQL is a leading vendor of tools for Microsoft SQL Server. ApexSQL products help SQL Server developers and DBAs accomplish complex tasks quickly, easily and accurately, including database auditing, recovery, change management, development, documentation and more. Headquartered in Raleigh, North Carolina, ApexSQL is a Microsoft Gold Certified Partner and has over 8,000 customers in over 120 countries worldwide.