I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the new features there is always need for a new Sample Database which contains all the necessary data and schema to demonstrate new features of the SQL Server. The SQL Server team has recently released a new sample database WideWorldImporters which can be used to demonstrate new features of the SQL Server.
Personally, I would have preferred that team would have an enhanced AdventureWorks database to accommodate the new features, but I am sure there would be some reason for coming up for entirely new sample database. It will take a while before we can all wrap our head around this sample database.
I have received quite a few requests to write about how to install this new sample database as it is not as simple as installing AdventureWorks due to the new features. I have created a quick video about the same, where I demonstrate how quickly we can install SQL Server 2016 sample database WideWorldImporters.
In this short video we will see how we can install SQL Server 2016 sample database WideWorldImporters.
Here are a few important links:
- Download Sample Database and Script from Video
- Download SQL Server 2016 Developer Edition for FREE
- Install SQL Server 2016 Management Studio
Reference: Pinal Dave (https://blog.sqlauthority.com)
Instead of creating number of repor (.rdl) is there any way to generate the report using dynamic parameter ,data set and fields
Example : In entry project i will create only one report (table format) , But different store procedure based on dataset , number of columns report should generate
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path ‘G:\SQL2012_FILES\MSSQL11.MSSQLSERVER\MSSQL\ReplData\unc\KAUSHIK-PC_DB_REPLICATION_REPLI_PUB\20160810205346\’ is denied.
Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity)
at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
Can we upgrade to SQL Server 2016 now, or should we wait for SP1? We are currently in SQL Server 2008r2.