User profile for ben_b

If I understand the question correctly, when configuring the database distribution lists you can expand the server node to drag in the database names. when I first used it I dragged the server node across and this was defaulting to .master so I was having to stick in USE statements - I thought that was how it worked until I looked again. / comments

If I understand the question correctly, when configuring the database distribution lists you can expand the server node to drag in the database names. when I first used it I dragged the server nod...

0 votes

Hi Tugberk First off I'll have to admit that I've never been involved with Microsoft licensing and I find the whole thing really opaque. I would also say that in most companies I've worked in, there hasn't really been anyone who understood it! As I understand it SQL Estate manager allows you to classify instances as Production, Test etc. It also picks up information regarding the number of cores, the sql server version/edition, the amount of memory on the server etc. If you are only paying for production instances, could it aggregate the above information so you can compare the number of core, standard/enterprise licenses you should have vs the number you have actually purchased. Other possible use cases might be recommendations - you may have a 2016 SP1 enterprise edition running with less than 128GB ram and no high-availability it might suggest that it would be worth considering standard edition. Or you may have a server running 2-cores but the minimum licensing is 4 cores so it may flag this up. I know CAL licensing, software assurance and legacy editions (i.e. Business Intelligence edition etc) may add too many variables into the mix, but licensing is part of what I would consider managing a SQL Server estate. Most companies I have worked in grow their production estate quite frequently (projects go live and a new production sql server is suddenly in play) but rarely decommission - and I very much doubt that licensing is considered when the pressure is on. Any tool that could help bring even a little clarity to this would be welcomed cheers Ben p.s. I still haven't installed the trial version of SQL Estate Manager so I need to do that - i'll also install the following and will probably have a better understanding of it all afterwards. 1. https://blogs.msdn.microsoft.com/markm/2015/02/17/inventorying-sql-servers-with-the-microsoft-assessment-and-planning-toolkit-map/ 2. idera inventory manager / comments

Hi Tugberk First off I'll have to admit that I've never been involved with Microsoft licensing and I find the whole thing really opaque. I would also say that in most companies I've worked in, the...

0 votes

is the product intended to help with Microsoft licensing at all? Agree with the above that I would be interested in Standalone trial / comments

is the product intended to help with Microsoft licensing at all? Agree with the above that I would be interested in Standalone trial

0 votes

This is a very reductive explanation but just to get you started... Red-Gate toolbelt = embedded inside SQL Server Management Studio Toad for Sql Server = a completely separate IDE If you have a team of SQL Server developers that have been using SSMS for years and are comfortable with it, they will be able to integrate and pick-up Red-Gates tools very quickly. If you have a team of Oracle developers who have all been using TOAD for years and you are migrating to SQL Server, you will probably find this will ease the transition. If you have a team of Oracle developers who have all been Oracle SQL Developer for years and you are migrating to SQL Server, Red-Gate again would be the better choice. Just so you are aware, I only started using Toad a few months ago against Oracle. It has a lot of features but I hated the cluttered interface and millions of buttons so I switched to Oracle Sql Developer. I would start off concentrating on red gate SQL Prompt and spend some time watching the short training videos on youtube. / comments

This is a very reductive explanation but just to get you started... Red-Gate toolbelt = embedded inside SQL Server Management Studio Toad for Sql Server = a completely separate IDE If you have a te...

0 votes

https://blogs.technet.microsoft.com/dataplatforminsider/2018/02/20/whats-new-in-ssms-17-5-data-discovery-and-classification/ I just saw this and thought it may be of interest if you haven't already seen it - similar to the free idera offering but looks better at first glance. / comments

https://blogs.technet.microsoft.com/dataplatforminsider/2018/02/20/whats-new-in-ssms-17-5-data-discovery-and-classification/ I just saw this and thought it may be of interest if you haven't already...

0 votes

I'm not too sure how the projects progressed to be honest. All of these projects seem to be driven using a top down approach originating at board level and the tasks I mentioned earlier were just part of the 'discovery' phase. What I am seeing from a lot of companies in this industry (London market insurance) is that GDPR working groups are not really involving BI teams (who probably understand the data flows pretty well) but are currently concentrating on generating lots of Policy Procedural Documents and readiness assessments. My current company are about to enter what they call the 'remediation phase' so hopefully we will start seeing some concrete steps. These sort of tools will definitely come into play although I do think a massive house-keeping exercise first will really simplify everything (deleting/rationalising applications, servers, databases, reports, file-servers etc.) I personally like wetherspoons approach [image] http://www.wired.co.uk/article/wetherspoons-email-database-gdpr / comments

I'm not too sure how the projects progressed to be honest. All of these projects seem to be driven using a top down approach originating at board level and the tasks I mentioned earlier were just ...

0 votes

Hi James. Good luck in your new role. A couple of my friends (Business Analysts) were given vague remits to try and track down sensitive data as part of fact finding mission for GDPR. One of your rivals had a really good free tool to get them started, Idera SQL Column Search. Its not as complete as what you were looking at with SQL Atlas but it was simple enough for them to use with their fairly limited database experience. cheers, Ben / comments

Hi James. Good luck in your new role. A couple of my friends (Business Analysts) were given vague remits to try and track down sensitive data as part of fact finding mission for GDPR. One of you...

0 votes

Sorry, i've just found it. Click on the green underlined keyword (don't just mouse-over) and press control. new functionality looks good / comments

Sorry, i've just found it. Click on the green underlined keyword (don't just mouse-over) and press control. new functionality looks good

0 votes

Hi Jamie. I'm giving this a go now. I cant seem to find how to switch on the 'Issue Details' pane as shown in the screenshot above? Any suggestions? I'm using SSMS 2012. cheers Ben Microsoft SQL Server Management Studio 11.0.3000.0 / comments

Hi Jamie. I'm giving this a go now. I cant seem to find how to switch on the 'Issue Details' pane as shown in the screenshot above? Any suggestions? I'm using SSMS 2012. cheers Ben Microsoft SQL Se...

0 votes

thanks both for all the info. will definitely have a look at git (probably having a crack at the TFS version first). I couldn't get the #A feature to work although I've never setup a TFS server before I didn't know if it was something on that side. I'm not sure if this uservoice details the same problem /redgate.uservoice.com/forums/39019-sql-source-control/suggestions/538567-add-ability-to-associate-check-ins-with-work-items If i setup a new TFS git repository i'll try using the #A work-item functionality at the same time. / comments

thanks both for all the info. will definitely have a look at git (probably having a crack at the TFS version first). I couldn't get the #A feature to work although I've never setup a TFS server b...

0 votes

How can we help you today?

ben_b

Comments