Trigger an automated build when you check changes into version control with SQL Source Control in SQL Server Management Studio, or via the SQL Change Automation Visual Studio extension. Set up new projects in s
SQL Change Automation Staying In-sync with drift correction Getting everyone in a team behind a process change is hard. As a database developer, not only do you need to champion the new process within your own team, but you also need to extend the olive branch to your DBA to ensure ...
We were in the process of refreshing our SQL Server shared service, so I moved the Teamcity database on to a newer SQL Server Always On cluster. After a bit of messing around I finally got the container version of Teamcity to work, and that’s how we have run for some time now. The...
After October 2016 I have become a MCP in SQL Server (exam 70-461). In order to obtain the certification, I have decided to start reading mainly SQL Server books. Thus, I have kindly requested some fromApress.Comfor a review and they havekindly send them. Being kind is really important...
was founded in 2018 with one goal to help clients reduce IT spending. We have a passion for data automation and database optimization and created SQLAI™ to do just that. The seasoned full time DBA with benefits, is well north of $150,000 annually. Most Database Administrators are ...
Once the DBA/DBE team realizes the utility of SQLAutomate it will become an integral tool for their job. SQLAutomate is very easy to install, easy to use and easy to purchase. Where is SQL Server Agent Express? Automate database maintenance and more... About SQLAutomate is available...
languages. Latin1_General_CI_AS does character expansions, where SQL_Latin1_General_CP1_CI_AS does not. You would need to discuss this further with your DBA since this will really depend on what the DB Server collation is set as, and what your needs are based on SQL vs Windows ...
In addition to the simple things you can do in SSMS (e.g. starting a job, backing up a database), we've also read a whole bunch of docs and came up with commands that do nifty things quickly. Lost sysadmin access and need to regain entry to your SQL Server? UseReset-DbaAdmin. ...
In addition to the simple things you can do in SSMS (e.g. starting a job, backing up a database), we've also read a whole bunch of docs and came up with commands that do nifty things quickly. Lost sysadmin access and need to regain entry to your SQL Server? UseReset-DbaAdmin. ...
He has been a Test Automation Manager, Test Architect, Developer and SQL Server DBA. He has MCSA(Microsoft Certified Solutions Associate) certification in SQL Server 2012. In his free time he provides trainings in Selenium WebDriver, Java Programming, BDD, Performance Testing, and SQL and also...