tag:blogger.com,1999:blog-7476247.comments2024-03-19T12:27:57.831+00:00Steven Wright BlogSteve Wrighthttp://www.blogger.com/profile/15679255693378492813noreply@blogger.comBlogger40125tag:blogger.com,1999:blog-7476247.post-53551220062351761892023-02-23T09:06:15.252+00:002023-02-23T09:06:15.252+00:00Nice article and good information shared by the au...Nice article and good information shared by the author. when you are isofttrainings with us we use it to assist with the education information blog.<br />Visit us - <a href="https://www.isofttrainings.com/azure-data-factory-online-training/" rel="nofollow">Azure Data Factory Online Training</a>isofttrainingshttps://www.blogger.com/profile/11004172869684284874noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-50465511835566758032022-08-23T09:34:25.060+02:002022-08-23T09:34:25.060+02:00Thank you so much for this nice information.
Indi...Thank you so much for this nice information.<br /><br /><a href="https://g.co/kgs/qx5M62" rel="nofollow">Indium Software</a><br /><br /><a href="https://www.indiumsoftware.com/data-analytics/" rel="nofollow">Data and analytics Services</a><br /><br /><a href="https://www.indiumsoftware.com/about/" rel="nofollow">Digital Engineering Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/databricks-services/" rel="nofollow">Databricks Consulting Services</a>Charleshttps://www.blogger.com/profile/17613066088163742432noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-51040430271222426992022-08-23T09:31:21.568+02:002022-08-23T09:31:21.568+02:00Thank you so much for this nice information.
Indi...Thank you so much for this nice information.<br /><br /><a href="https://g.co/kgs/qx5M62" rel="nofollow">Indium Software</a><br /><br /><a href="https://www.indiumsoftware.com/data-analytics/" rel="nofollow">Data and analytics Services</a><br /><br /><a href="https://www.indiumsoftware.com/about/" rel="nofollow">Digital Engineering Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/databricks-services/" rel="nofollow">Databricks Consulting Services</a>Charleshttps://www.blogger.com/profile/17613066088163742432noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-29207276670531161502022-06-29T08:07:37.084+02:002022-06-29T08:07:37.084+02:00Top Notch article, it is particularly valuable! I ...Top Notch article, it is particularly valuable! I unobtrusively began in this, and I'm transforming into more familiar close by inside the focal point of it better! Delights, articulation war more and hauling continuing extraordinary! <a href="https://crackdj.com/card-recovery-full-crack-key/" rel="nofollow">Card Recovery Key</a>trubloggerhttps://www.blogger.com/profile/15236733515536454987noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-73840848075209526962022-05-19T13:18:02.284+02:002022-05-19T13:18:02.284+02:00I appreciate you taking the time and effort to sha...I appreciate you taking the time and effort to share your knowledge. This material proved to be really efficient and beneficial to me. Thank you very much for providing this information. Continue to write your blog.<br /><br /><a href="https://www.indiumsoftware.com/data-engineering/" rel="nofollow">Data Engineering Services</a> <br /><br /><a href="https://www.indiumsoftware.com/ai-ml-solutions/" rel="nofollow">Artificial Intelligence Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/data-analytics/" rel="nofollow">Data Analytics Services</a><br /><br /><a href="https://www.indiumsoftware.com/bi-data/" rel="nofollow">Data Modernization Solutions</a>Matthew Staffordhttps://www.blogger.com/profile/02521411089444868805noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-41148151291120867602022-05-09T07:10:39.623+02:002022-05-09T07:10:39.623+02:00I appreciate you taking the time and effort to sha...I appreciate you taking the time and effort to share your knowledge. This material proved to be really efficient and beneficial to me. Thank you very much for providing this information. Continue to write your blog.<br /><br /><a href="https://www.indiumsoftware.com/data-engineering/" rel="nofollow">Data Engineering Services</a> <br /><br /><a href="https://www.indiumsoftware.com/ai-ml-solutions/" rel="nofollow">Machine Learning Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/data-analytics/" rel="nofollow">Data Analytics Solutions</a><br /><br /><a href="https://www.indiumsoftware.com/bi-data/" rel="nofollow">Data Modernization Services</a>Michale Davidhttps://www.blogger.com/profile/09631958214033967930noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-30080295693339209932022-03-22T12:57:53.949+00:002022-03-22T12:57:53.949+00:00The information you've shared on Azure Migrati...The information you've shared on <a href="https://techomsystems.com.au/azure-sentinel/" rel="nofollow">Azure Migration</a> has really pleased me. It's a fascinating article, both for me and for others. Thank you for bringing such interesting topics to our attention.<br />techomsystemhttps://techomsystems.com.au/noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-70990677968749761992018-08-30T17:48:41.370+02:002018-08-30T17:48:41.370+02:00When running the Defrag-SQLServer-Indexes script I...When running the Defrag-SQLServer-Indexes script I get the error stated below. I am running this in powershell 2.0 on a 2008 R2 server with sql 2008 r2 sp3 installed. I did verify that Microsoft.SqlServer.Smo is installed... Any thoughts on how to resolve?<br /><br /><br />New-Object : Cannot find type [Microsoft.SqlServer.Management.SMO.Server]: make sure the assembly containing this type is loaded.<br />At C:\temp\Defrag-SQLServer-Indexes.ps1:95 char:19<br />+ $srv = New-Object <<<< -TypeName Microsoft.SqlServer.Management.SMO.Server -ArgumentList $server<br /> + CategoryInfo : InvalidType: (:) [New-Object], PSArgumentException<br /> + FullyQualifiedErrorId : TypeNotFound,Microsoft.PowerShell.Commands.NewObjectCommand<br /> <br /><br /><br /><br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-44197898135804417182018-03-02T04:12:50.668+00:002018-03-02T04:12:50.668+00:00Thanks for splitting your comprehension with us. I...Thanks for splitting your comprehension with us. It’s really useful to me & I hope it helps the people who in need of this vital information. <br /><a href="http://www.greenstechnologys.com/devops-training-and-certification-in-chennai.html" rel="nofollow">Devops Training in Chennai</a><br /><a href="http://www.greenstechnologys.com/devops-training-and-certification-in-chennai.html" rel="nofollow">Devops Training Institute in Chennai</a><br />Anonymoushttps://www.blogger.com/profile/05302572107608613894noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-79912578815128380072018-02-01T08:08:00.629+00:002018-02-01T08:08:00.629+00:00Thanks a lot !!!. It worked fine.Thanks a lot !!!. It worked fine.Arunhttps://www.blogger.com/profile/15895990700779227458noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-86101913052183707352018-02-01T08:07:16.397+00:002018-02-01T08:07:16.397+00:00Thank you, It really worked.Thank you, It really worked.Arunhttps://www.blogger.com/profile/15895990700779227458noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-51809288897229997492016-11-07T20:56:50.793+00:002016-11-07T20:56:50.793+00:00There is not a command line tool to create a publi...There is not a command line tool to create a publish profile. However you could from create the a file yourself as it just and XML file. You could use a profile create from the GUI tool as a template file.Steven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-51329819501781970532016-11-07T11:24:52.184+00:002016-11-07T11:24:52.184+00:00Hi Steven,
Is it possible to create the publish pr...Hi Steven,<br />Is it possible to create the publish profile from the command line, not from the GUI?Anonymoushttps://www.blogger.com/profile/06371881076138385155noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-61387972493095099552016-06-06T21:45:21.400+02:002016-06-06T21:45:21.400+02:00The link to the XML file appears to be dead. Do y...The link to the XML file appears to be dead. Do you have a better link? Thank you!<br /><br />Mike millerAnonymoushttps://www.blogger.com/profile/00809535740346829734noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-32140675361037946202016-06-06T21:44:19.390+02:002016-06-06T21:44:19.390+02:00The link to the XML file appears to be dead. Do y...The link to the XML file appears to be dead. Do you have a better link? Thanks!<br /><br />Mike MillerAnonymoushttps://www.blogger.com/profile/00809535740346829734noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-31691061761986324842015-07-08T17:15:18.330+02:002015-07-08T17:15:18.330+02:00Hi Steve,
I've wrapped your T4s into Nuget pa...Hi Steve,<br /><br />I've wrapped your T4s into Nuget package for simplicity (https://www.nuget.org/packages/T4tSQLtMSTestCodeGen/1.0.0). Now you can just create new Unit Test project, add Nuget reference to T4tSQLtMSTestCodeGen, replace [YOUR DATABASE NAME] hardcoded in app.config and runme.tt and just save runme.tt to generate Unit Tests.<br /><br />Source code is available here https://github.com/aiacovlev/T4tSQLtMSTestCodeGen<br />Hope this help,<br />Alex..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-8989198626906339542015-04-12T21:43:05.262+02:002015-04-12T21:43:05.262+02:00Hi Greg
When using SQLPackage to export the tsq...Hi Greg<br /> When using SQLPackage to export the tsqlt database there should have been a DLL file eported as well. This DLL file needs to be copied the DACPAC as well. <br /><br />Regards<br />SteveSteven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-20904050683880853922015-04-07T03:14:59.864+02:002015-04-07T03:14:59.864+02:00Hi, I'm trying to export the .dacpac and while...Hi, I'm trying to export the .dacpac and while that appears to work, when I make the reference, it is complaining that the associated .dll isn't found. Are there extra steps needed to included the CLR stored procedures in the .dacpac? <br />Thanks!<br />GregAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-34931466436484599132014-12-22T15:23:57.310+00:002014-12-22T15:23:57.310+00:00Thanks, this gem saved me so much time.
After was...Thanks, this gem saved me so much time. <br />After wasting time trying sqlpackage.exe, PowerShell and SSMS I just wish I had found it sooner :-)Anonymoushttps://www.blogger.com/profile/14713364675151926117noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-59565479702808117082014-11-28T10:36:25.109+00:002014-11-28T10:36:25.109+00:00Cheers fella, worked a treat.Cheers fella, worked a treat.Colin McNultyhttp://www.colinmcnulty.comnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-72888734188671051932014-10-06T13:16:13.303+02:002014-10-06T13:16:13.303+02:00Hi Lee Anne.
After you create a C# Unit Test Proj...Hi Lee Anne. <br />After you create a C# Unit Test Project you will need to manually add a Sql Server Unit Test. This will then get visual studio to update the project with the required references, which I think is causing your problem. <br /><br />Also it will add a require class file call: SqlDatabaseSetup.cs prompt you add connection string for the database the unit test will be executed against.<br /><br />Regards<br />Steve WrightSteven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-85731762121099144392014-10-02T15:34:33.624+02:002014-10-02T15:34:33.624+02:00Visual Studio noob here again. Now that I've g...Visual Studio noob here again. Now that I've gotten some tests written, I want to automate testing. I installed the extension and loaded your project. It generates a file for the single test schema I have, but once moved into the Unit Test project, it won't compile. I'm not entirely sure I have an MS-Test project. I added the Visual C# Unit Test Project - is that MS-Test?<br /><br />Some of the errors I get:<br />Expected ; or = (cannot specify constructor arguments in declaration)<br />Invalid token '{' in class, struct, or interface member declaration<br />A namespace annot directly contain members such as fields or methods<br /><br />If I just need to set up MS-Test, a pointer to some instructions would be appreciated!<br /><br />Thanks,<br />Lee AnneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-32047371560567710752014-09-06T00:42:01.651+02:002014-09-06T00:42:01.651+02:00Excellent, thank you! Got this set up and working ...Excellent, thank you! Got this set up and working now, and I had forgotten about the 'Include Composite Projects' check since I initially set up my solution.<br /><br />Thanks,<br />Lee AnneAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7476247.post-28602117271939331882014-09-05T12:23:44.556+02:002014-09-05T12:23:44.556+02:00Hi Lee Anne, You will need to ensure that the tsql...Hi Lee Anne, You will need to ensure that the tsqlt.dacpac is added into source control. <br /><br />The way I handle this was to create a Solution folder call Reference then added the tsqlt.dacpac file. This will then allow Visual Studio to download the file when you, or someone else, does a Get Latest at the solution file level. <br /><br />When Comparing the project against a target database you will need to set the following option: Include Composite Objects which is under General Tab. This will make the compare treat References as part of project and compare them against the target database update/create/delete as appropriate. <br /><br />For more information about Reference here is a link: http://msdn.microsoft.com/en-us/library/jj684584(v=vs.103).aspx<br /><br />Regards<br />SteveSteven Wrighthttps://www.blogger.com/profile/10250648827790297322noreply@blogger.comtag:blogger.com,1999:blog-7476247.post-29344370799985625702014-09-04T22:59:02.146+02:002014-09-04T22:59:02.146+02:00Visual Studio noob here. Do you have to do anythin...Visual Studio noob here. Do you have to do anything with the .dacpac after making a reference to it? Does it magically end up in source control somehow, or does it need to be manually added to the project?<br /><br />After adding the reference, I did a compare between the new tSQLt database project and the database that I created the .dacpac from, and the project wanted to delete all the non-existent objects from the database. Perhaps you can also point me to some pages that explain how to work with .dacpacs as references?<br /><br />Thanks,<br />Lee AnneAnonymousnoreply@blogger.com