The Curious Engineer

All blogs / Databases

Developer hearted / Relational minded

learn.microsoft.com/en-us/archive/blogs/jenss

DatabasesDev tools / editors / IDEsMicrosoft blogsMSDN archive

’10’15’20’25
Posts
87 from 20 Feb 2008 to 5 May 2015
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/jenss/feed.xml

2015 1

  1. [Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version 0.3.0.0

2014 2

  1. Setting things in the right compatibility view (Visual Studio 2005 / 2008 / 2010 / 2012 / 2013 / BIDS / BI Development SSAS SSIS SSRS SSDT, SQL Server 2005 / 2008 / 2008R2 / 2012 / 2014)
  2. Bulk Backup and Restore at the tip of your finger <New version>

2013 9

  1. [Updated]: Light weight SQL Server procedure auditing without using SQL Server auditing version 0.2.1.0
  2. Finally, the family…united. SQL Server BI Project templates now available in Visual Studio 2012
  3. SQL Server Reporting Services Load Simulator v 0.2.0.0
  4. PowerShell StdOut go out, StdErr go everywhere
  5. Blog Resources online again !
  6. Where have all the objects gone, long time passing ? (Version 0.1.0)
  7. Headless build can make you scratch your head (Part 1)
  8. Why the name of the service ist not the ServiceName, is not the ServiceName
  9. The help for “The database schema provider could not be determined…”

2012 2

  1. Outage: External sample server down
  2. Update to SQLCmdScriptExpander => 0.2.0.0 is out

2011 1

  1. IsGuid or not isGuid, that is the question…

2010 11

  1. Get the NULL percentage of values in a specific table dynamically
  2. ALM Visual Studio Database Projects Guidance is out in the wild !
  3. Expand :r referenced files for SQLCMD into one file (SQLCmdScriptExpander)
  4. Script out jobs in SQL Server v2
  5. Database internal file versions– How to determine if the database was upgraded or created from scratch
  6. Did your SQL Agent doze off and you don´t know which jobs to run afterwards ?
  7. Database internal file versions–Where is the Undo button for a database upgrade ?
  8. SSIS as a data source for SSRS–where is it gone for SQL Server 2008 R2
  9. Usage of @@Trancount in DML statements
  10. Light weight SQL Server procedure auditing without using SQL Server auditing version 2
  11. The New! report in town

2009 38

  1. Want to know what happened on your database by reading the transaction log ?
  2. An “secret” SSIS XML Destination Provider you might not found yet
  3. SSIS as a data source needed ? Watch out for configuration traps
  4. SQLIOSIMParser 0.3.3.0 is available
  5. SQLIOSimParser 0.3.1.0 is available
  6. Jump on the Express Trace if you can – SQL Server Express server side tracing
  7. New Cumulative Update for CU4 for SQL Server 2008 SP1
  8. Project corruption after upgrade VSTSDB & Unit tests
  9. Basta Herbst 2009 in Mainz
  10. SQLDays in Rosenheim Herbst 2009
  11. Need more spare time ? Use SQLIOSimParser to interpret your IO results !
  12. Problems opening your project files in Visual Studio ?
  13. Cannot find the source of a SQL Server error ?
  14. (Log) resistance is futile – how to drop log files
  15. Database Programming: Did You Know IN Can Do This?
  16. List reports of a Reporting Services instance via rs.exe script
  17. CU6 for SQL Server 2008 / CU3 SQL Server 2008 SP 1 are out
  18. Light weight SQL Server procedure auditing without using SQL Server auditing
  19. The “magic” about trustable relationships with NULL and NOT IN
  20. Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 2
  21. Getting feedback / progress from batches and stored procedures
  22. A long (but not missed) friend revisited, prefixing stored procedures with SP_
  23. Perception vs. reality, how to keep your database schema changes of different environments aligned with VSTSDB and VSDBCMD.EXE Part 1
  24. Consuming SSIS package data in Reporting Services (and using Web Services in addition) Part 1
  25. VSTS 2008 Database Edition GDR R2 is released
  26. Getting relational data as well formed XML structures out of SQL Server
  27. Getting a list of all facets and its properties
  28. SQL Server 2008 SP1 CU1 is out
  29. SQL Server 2008 SP1 + CU1 or CU4 or what ?
  30. Who2 wants to process sp_who2 ?
  31. Checking Failover after setting up a Database Mirroring
  32. TDS Protocol Versions meet client stacks
  33. Need a good book for lonely evenings ? The new updated BOL 2008 (January 2009) is available !
  34. Script out Jobs in SQL Server
  35. Change the edition in SQL Server 2008
  36. Why a random row sometimes shows random data...
  37. Determine the current status of a SQL Server Agent job
  38. Tedious trigger generation getting simplified

2008 23

  1. FriendlyDateDiff
  2. Basta / SQLCon 2008 Slides and samples online
  3. Merge it your own way -- Followup on the test
  4. CTP15 of the GDR release of VIsual Studio for Database Professionals is available
  5. Get all system databases of a server
  6. Problems installing Security Update for SQL 2005 SP2 (KB948109)
  7. VSTS 2008 Database Edition GDR June CTP
  8. VSTS Database Edition having problem creating UnitTests
  9. Changing the Login / Authentication Mode programmtically via SMO
  10. Obfuscation is not a security feature – Spoofing the APP_NAME
  11. Merge it your own way - Comparison of SQLAdapter vs. SQLCommand vs. MERGE
  12. Linq to SQL materials of the SQL Server Developer Conference (SEK) in Nürnberg
  13. Enumerating Parameter Collection in SQL Server Reporting Services
  14. We heard the voices... SP3 for SQL Server 2005 is coming
  15. Determine the (available) amount of memory of a SQL Server (instance / machine)
  16. Renaming sysprepred SQL Servers via script
  17. Visual Studio Team Database Edition 2008 - Where to get SR1 for this ?
  18. Visual Studio 2005 Team System Database Professional post Service Release 1 (SR1) roll-up package 1 is now available
  19. Custom Security in SQL Server Analysis Services 2005/2008
  20. Basta Spring 2008 ! Slidedecks online
  21. Launch SQL Server 2008 samples online
  22. SQL Server 2008 Launch Content und Fragen
  23. A new blog was (re-)born !