Forum Widgets
Latest Discussions
Looking for SQL sessions at Microsoft Ignite?
The Microsoft Tech Community is the official online community for Microsoft Ignite! Join in conversations about sessions you're excited to attend by clicking here: https://techcommunity.microsoft.com/t5/forums/filteredbylabelpage/board-id/MicrosoftIgniteContent/label-name/sql%20server These are all of the conversations aligned to each Breakout, each Theater session that cover SQL Server. This is not an exhaustive list - there is more to come and updates are happening on MyIgnite every day up until the event. We will be embedding the final decks and recordings here once they are available.
Schedule an SSIS package
Hi team, I created multiple packages in SSIS. Source connection manager is Excel/ Oracle Database and Target connection manager is ODBC(Snowflake cloud) so we created packages and containers. Now, we want to schedule those. I tried by deploying a project in SSMS and by creating a new job. In the job, I added job steps and gave a schedule time. Every time it is getting failed due to the below error. If I use target connection manager OLE DB(SQL) I'm able to schedule the packages successfully. Date 3/22/2022 9:49:16 AM Log Job History (JOB) Step ID Server DESKTOP-2B7TI5T Job Name JOB Step Name Duration 00:00:03 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message : The job failed. The Job was invoked by User DESKTOP-2B7TI5T\Rajeswari. The last step to run was step 1 (AR). Below are the SQL server management studio Details: SQL Server Management Studio 15.0.18358.0 SQL Server Management Objects (SMO) 16.100.44091.28 Microsoft Analysis Services Client Tools 15.0.19260.0 Microsoft Data Access Components (MDAC) 10.0.22000.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.22000 Please guide me how to achieve this with brief steps. Thanks.SQL Server Certifications
Recently, I have spoken at several user groups and/or SQL Saturday events on SQL Server Certifications. I have posted my powerpoint presentation below. But I thought I would give a quick overview. First you will need to start by earning one of the four eight MCSA cerfitications. You have the classic MCSA: SQL Server 2012/2014 certification which has been available for several years. Or, you could obtain one of the newer SQL Server 2016 MCSA certifications in either Database Development, Database Administration, or BI Development. (Four new SQL Certification introduced in Spring 2017 are listed at the bottom of this post.) I really like the new streamlined 2016 certifications because you can focus on your area of expertise and you only need two exams. With the SQL Server 2012, you needed a broader knowledge base to earn the MCSA certification. I for one had difficulty with the 70-463 exam as I do not work with Data Warehousing on a regular basis, but I had to learn that material for the exam. If you still want to demonstrate your breadth of knowledge, there is nothing to stop you from earning more than one MCSA. Once you have earned your MCSA, it is now even easier to earn you MCSE. You only need to take ONE of the exams from the electives listed in the next picture to obtain an MCSE. What is even better is that your MCSE no longer expires. However, you can re-earn the MCSE by taking an additional elective exam in subsequent years. I really like this option, because in years past I would need to study older material to renew my MCSE. Now, I can learn new skills for new exams each year while I re-earn my MCSE. UPDATE: (March 22, 2017) You can now retake an exam that you have already passed to re-earn your MCSE certification, however you must wait at least 365 days from when you passed the exam before being allowed to take the exam again. You can still earn the two older MCSE certifications (Database Developer or BI Developer) until March 31, 2017. After that only the MCSE: Data Management & Analytics will be available. Don't forget that once you pass an exam or obtain a certification, head over to the Acclaim website to pick up your shiny, new badge that you can use on social media to show your freinds, family, and co-workers. UPDATE: (April 12, 2017) Four new MCSA certifications were announced today. (Update May 23, 2017) Names of new MCSA certifications have changed.
Disk size considerations
Hello. Could you suggest if there are any considerations regarding disk size for database files? Are there any limitations from MS SQL? Version that we use is SQL 2014 SP1. What we need is handling 200+ SharePoint content databases of total size about 16TB. So the question is whether it will be better from the SQL perspective to have, say, 4 x 4TB logical disks instead of one 16TB disk. Or are there only hardware considerations to take into account, but not SQL-related? Alex
