Profile cover photo
Profile photo
Brian Lockwood
644 followers -
Marketing and Technical Operations Manager - Apex SQL
Marketing and Technical Operations Manager - Apex SQL

644 followers
About
Brian's posts

Post has shared content
How to prevent performance problems and errors due to wildcards in SELECT statements

If your SQL queries perform sluggishly and severely impact SQL Server performance, the solution can be closer than you think.

Check out this article: http://bit.ly/UzQOyb

Read the post below for more information.

#SQL #sqltuning #sqlperformance 
How to prevent performance problems and errors in SELECT statements
by: +Venijamin Zivkovic 

There are a number of reasons your queries don’t perform that fast or impact the #sqlserver performance, and usually the solution to that issue boils down to rewriting the offending #sqlquery from scratch. However, sometimes a solution that doesn’t involve recreating the entire query exists and might be a lot closer than you think 

To find out what it is, check out this article - http://bit.ly/UzQOyb

+++++++++++++++++++++++++++++++++++++++++++++++++++++++
#SQL #sqltuning #sqlperformance  

Post has shared content
Checklist for suspicious activity on the SQL Server

It looks like something went wrong with the SQL server.
There are reports of or database objects and data being damaged or missing.

Wondering what to do?

Check this article: http://bit.ly/RYaW08

Read the post below for more info.

#SQL #sqlsecurity
Checklist for suspicious activity on the SQL Server
by: +Venijamin Zivkovic 

It seems something went awry with the #sqlserver. It’s sluggish, behaves erratically, produces heavy network traffic, there is a significant increase in the server processor or memory utilization, and to top it all there are reports of #sqldatabase objects and data being damaged or missing.

Where to start looking?

See this article: http://bit.ly/RYaW08 to find out

+++++++++++++++++++++++++++++++++++

#SQL #sqlsecurity  

Post has shared content
How to rename a column without breaking your SQL database

Renaming a table or view column is not something a SQL developer needs to do every day. But when the time comes, how can it be done easily and effortlessly?

Check out this article for the solution: http://bit.ly/TPV13c

Read the post below for more details.

#SQL   #sqlserver   #SQLdevelopment
How to rename a column without breaking your SQL database
by: +Milena Petrovic 

Renaming a column would be a piece of cake, if it weren`t for the objects that reference the renamed column

The good news is – ApexSQL has a completely free tool that renames columns without breaking scripts and dependencies

You don’t have to worry about dropping and recreating dependent objects, have ApexSQL Search do that for you 

Check out this article http://bit.ly/TPV13c on how to rename your columns effortlessly and safely 

+++++++++++++++++++++++++++++++++++++++++++++

#SQL   #sqlserver   #SQLdevelopment

Post has shared content
How to document SQL databases automatically

Having up-to-date database documentation will not save your life,
like database and transaction log backups will, but it’s still very important.
You can schedule the documenting process similarly to the way you schedule database and transaction log backups.

Check out this article: http://bit.ly/11MLCuN to see how to schedule database documentation.

Read the post below for more information.

#SQL   #sqlserver   #sqldatabase  
Up-to-date database documentation always at hand
by: +Milena Petrovic 

Wash the dishes, feed the cat, document the databases… There are some things you can do with less effort - use cardboard plates, ditch the cat and schedule documentation.
We can help with the last one. Leave it on your DBA check list, and set the time needed to do it to 0.

Check out this article: http://bit.ly/11MLCuN to see how to schedule database documentation.

#SQL   #sqlserver   #sqldatabase  

Post has shared content
Holiday specials!

Save big on all the tools your #SQL developers and DBAs will ever need with a 20% discount on ApexSQL Universal Studio this Christmas!

Learn more: http://tinyurl.com/cwe6aa9

#SQLtools
Photo

Post has shared content
ApexSQL Data Diff 2012 released – Performance improvements and SSMS integration

ApexSQL Data Diff 2012 - The new version introduces significant performance improvement, seamless SQL Server Management Studio integration and more.

============================================
Check it out: http://bit.ly/116D4yF
============================================

Read the post below for more details.

#sqlserver2012 #schemacompare  
Fast don’t lie – #ApexSQL Data Diff 2012 has been released
by: +Venijamin Zivkovic 

A new version of your favorite #changemanagement tool is available and we believe it to be one of the fastest #SQL data comparison and synchronization products in the world! 

ApexSQL Data Diff is a #sqlserver data comparison and synchronization tool which detects differences between database objects and resolves them without errors. It generates comprehensive reports on the found differences and can automate the synchronization process between live, native and natively compressed backups

Did we mention it integrates with #SSMS as well?

Check it out at +ApexSQL software 

============================================
Read more on our blog: http://bit.ly/116D4yF
============================================

#sqlserver2012 #schemacompare  

Post has shared content
Has a SQL injection attack damaged your data?

So, SQL injection attack has occurred and your data is all messed up.

There is a possible solution.

Check out this article http://bit.ly/Wn1Q9y to see how to roll back SQL injection actions on your database and bring your data back to its original state.

Read the post below for more details.

+++++++++++++++++++++++++++++++++++

#datarecovery #disasterrecovery #SQLinjection #rollback
Has a SQL injection attack damaged your data? We can help
Author: +Milena Petrovic 

You've just realized that you're a victim of a SQL injection attack
Your data is all messed up - some of it has been deleted, some tables truncated or dropped, some existing records updated and even some new ones added

Check out this article http://bit.ly/Wn1Q9y to see how to roll back SQL injection actions on your database and bring your data back to its original state

+++++++++++++++++++++++++++++++++++

#datarecovery #disasterrecovery #SQLinjection #rollback

Post has shared content
Your search is over – The ApexSQL Search introduction video

Check out another awesome video from ApexSQL's very own Martin, providing a detailed introduction to #ApexSQL Search, a FREE #sqlserver Management Studio and Visual Studio add-in.

Watch the video: http://tinyurl.com/ck9qotl

Read the post below for more details.

#sqlserver2012 #visualstudio #sqlserver
Your search is over – The ApexSQL Search introduction video
Author: +Venijamin Zivkovic   

Another awesome video from ApexSQL's very own Martin, providing a detailed introduction to #ApexSQL Search, a FREE #SSMS and Visual Studio add-in, which allows you to search for #sqldatabase objects and data, and renames objects without breaking dependencies while visualizing all relationships between #SQL objects 

===============================================
Watch the video: http://tinyurl.com/ck9qotl
===============================================

#sqlserver2012 #visualstudio #sqlserver

Post has shared content
You’ve deleted, truncated or dropped data? There is a cure

You’ve inadvertently executed (or experienced other data loss scenarios involving) a DELETE, TRUNCATE or DROP statement against a database and lost valuable records

How can you bring the data back?!?!
Check out this article http://bit.ly/TMhj0y to see how to accomplish a ‘Mission impossible’ 

Read the post below for more details.

#sqlserver #ApexSQL #datarecovery
You’ve deleted, truncated or dropped data? There is a cure
Author: +Milena Petrovic 

A moment of distraction and your data is deleted, truncated or dropped. In other words, lost. To make things worse, you don’t have a full database backup, cannot take the database offline, and some transactions were made on the database after the data was lost

Check out this article http://bit.ly/TMhj0y to see how to accomplish a ‘Mission impossible’ 

#sqlserver   #ApexSQL   #datarecovery  

Post has shared content
Your search is over – The ApexSQL Search introduction video 

Check out another awesome video from ApexSQL's very own Martin, providing a detailed introduction to #ApexSQL Search, a FREE #sqlserver Management Studio and Visual Studio add-in.

Download here: http://www.apexsql.com/sql_tools_search.aspx

Read the post below for more details.

#sqlserver #ApexSQL #freesoftware
Your search is over – The ApexSQL Search introduction video
Author: +Venijamin Zivkovic  

Another awesome video from ApexSQL's very own Martin, providing a detailed introduction to #ApexSQL Search, a FREE #sqlserver Management Studio and Visual Studio add-in, which allows you to search for #sqldatabase objects and data, and renames objects without breaking dependencies while visualizing all relationships between #SQL objects 

============================================
Download it at: http://www.apexsql.com/sql_tools_search.aspx
============================================

#sqlserver2012 #visualstudio #freesoftware
Wait while more posts are being loaded