Profile

Cover photo
Brian Lockwood
Works at Apex SQL
Attended Faculty of Electronics - Nis
Lives in Nis
591 followers|6,637 views
AboutPostsPhotosVideos

Stream

Brian Lockwood

Shared publicly  - 
 
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  
1
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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
1
Add a comment...

Brian Lockwood

Shared publicly  - 
 
 
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
5
Marijana Miletic's profile photo
 
this looks perfect, I love it!
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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
3
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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  
3
Add a comment...
Have him in circles
591 people

Brian Lockwood

Shared publicly  - 
 
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  
1
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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  
3
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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  
3
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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
4
Add a comment...

Brian Lockwood

Shared publicly  - 
 
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
5
Add a comment...
People
Have him in circles
591 people
Work
Occupation
Marketing and Technical Operations Manager
Employment
  • Apex SQL
    Marketing and Technical Operations Manager, 2008 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Nis
Previously
Raleigh
Story
Tagline
Marketing and Technical Operations Manager - Apex SQL
Introduction
I'm dedicated to improve awareness of ApexSQL excellent products and ApexSQL brand but I'm also coordinating the technical operations team including system administrator and webmasters.

My Interests

I would be really interested in sharing with and following people who post about specific topics.  

  • Database Administration
  • SQL Development
  • Search Engine Optimization
  • Web Design
  • Graphic Design
  • Photography & Art
  • Blogging
  • Search Engine Marketing
  • Social Media
  • Google+
  • Internet Marketing
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.

Great software

We strive to ensure that every one of our tools is a "Best of Class" product in its product class, from feature set, to performance, to interface, to quality. We know you won't be happy with anything less, and neither will we. Our many testimonials from over 8,000 customers underscore our commitment to this goal. Take a look at our free sql formatter.

 Great ROI

We are constantly adding new products and adding value to our existing products ensuring the maximum ROI for our customers who have invested in subscription plans

See our what's new page for our recent releases:

Apex SQL Software - News

See our what’s next page for our product release roadmap:

Apex SQL Software - What's Next

 Great bundles

ApexSQL has one of the largest number of SQL Developer tools in the industry. These software bundles, like ApexSQL Developer Studio allow convenient download, install and purchase of an entire set of tools, all at a big discount. Take a look for more bundles

 Great quality

We’ve invested heavily in quality, from a large QA team, to proprietary software developed specifically to test our own software, to a vibrant customer engagement effort that rewards defect reports, to complete transparency via alphas, betas, and even nightly experimental builds

 Great support

Our goal is to provide the best support in the industry on a daily basis. Our dedicated team is focused on answering every question in a simple direct manner, researching the issue so you don’t have to, and resolving your issue as quickly as possible. To learn more about our team and our product support visit our Support center

 Great service

We firmly believe our customer service team is truly awesome as evidenced by our many customer testimonials. We don’t want our customers to have to go through contact forms or search through FAQs to get an answer to a question. Any service question, issue, problem or concern can just be emailed to customers@apexsql.com to get a prompt and professional reply. To learn more about our team and our services visit our Service center

 Great community

We not only value our community we rely on it to provide critical feedback on our tools. We take community feedback, suggestions, criticisms and act on them to improve our software. We host a dedicated product support forum available to any evaluator or customer, regardless of subscription level. We offer early access via alphas, betas, experiment and nightly releases and if needed customer specific patches

 Great people

Our people are our DNA, representing a diverse cross section of knowledge workers from around the world, including 7 countries and 10 languages. Here is a glimpse of the many faces that make up ApexSQL

Education
  • Faculty of Electronics - Nis
Basic Information
Gender
Male