Profile cover photo
Profile photo
Jeremy Kadlec
235 followers -
Maryland SQL Server Consultant and Co-Founder of MSSQLTips.com
Maryland SQL Server Consultant and Co-Founder of MSSQLTips.com

235 followers
About
Jeremy's posts

SQL Server AlwaysOn: Availability Groups & Clustering in 1 hour

This webcast will demonstrate some tips and traps when working with SQL Server AlwaysOn Availability Group and Windows Server Failover Clustering (WSFC).

Author: Simon Liew

>>> https://www.mssqltips.com/webcastSignupPage.asp?id=619&src=GP

Post has attachment
Adding SQL Server Tools to the PATH Environment Variable on Linux

You want to run SQL commands with the sqlcmd tool on a Linux terminal, but you don't want to have to change to the tools folder for every terminal window you open. In this tip I will show you how to set the $PATH environment variable on Linux.

Author: Daniel Farina

>>> https://www.mssqltips.com/sqlservertip/4771/adding-sql-server-tools-to-the-path-environment-variable-on-linux/

Gather Storage Subsystem Performance Metrics Using the Diskspd Utility for SQL Server Applications

This tip will look at using the DiskSpd utility to gather performance metrics to make sure storage is not an issue for your SQL Server performance.

Author: Ben Snaidero

>>> https://www.mssqltips.com/sqlservertip/4770/gather-storage-subsystem-performance-metrics-using-the-diskspd-utility-for-sql-server-applications/

Post has attachment
Use SSMS to Restore a SQL Server database on a Linux based instance from a backup on a Windows instance

Learn the step by step process to restore a SQL Server database on a Linux based instance from a backup on a Windows instance with SQL Server Management Studio.

Author: Manvendra Singh

>>> https://www.mssqltips.com/sqlservertip/4655/use-ssms-to-restore-a-sql-server-database-on-a-linux-based-instance-from-a-backup-on-a-windows-instance/

SQL Server Business Intelligence Tips

Build your SQL Server Reporting Services SSRS, Integration Services SSIS and Analysis Services SSAS knowledge on all versions of the SQL Server platform.

>>> https://www.mssqltips.com/sql-server-business-intelligence-resources/

The Real World of the Database Administrator

This detailed report compiles input from 300 DBAs like you, comparing and contrasting their responses to pertinent questions such as: Are traditional database-management systems still dominant? Which tasks are being automated? And more...

>>> https://www.mssqltips.com/sql-server-whitepaper/118/the-real-world-of-the-database-administrator/

Next Webcast - Utilizing Free Tools to Optimize and Tune SQL Server

SQL Server comes with many tools to help optimize and tune performance, such as traces, extended events, execution plans, dynamic management views and more. In order to make the correct changes you need to know what tool to use...

>>> https://www.mssqltips.com/webcastSignupPage.asp?id=608&src=GP

Next Webcast - Taking advantage of Azure’s latest features for your next SQL Server deployment

Microsoft Cloud and Datacenter MVP, David Bermingham, reviews some of the latest Azure innovations and shows you how to take advantage of them in your next SQL Server deployment in Azure.

>>> https://www.mssqltips.com/webcastSignupPage.asp?id=597&src=GP


Post has attachment
Simplify Enterprise Application Integration with JAMS

Our organization spends significant time and money on integrating applications (ERP, CRM, cloud, mainframe, custom, etc.) across our enterprise. We have a number of experts on each platform, but when we need to integrate the data between systems we run into countless issues. How can we leverage our internal application expertise, but ease the integration portion? What options are available from an integration perspective?

>>> https://www.mssqltips.com/sqlservertip/4589/simplify-enterprise-application-integration-with-jams/

Post has attachment
Querying SQL Server Agent Job Information

I am a BI developer and have been moved recently to a DBA role. Among the many tasks that I am responsible for, two major ones are: monitoring the SQL Server Agent Jobs running on a set of servers by creating a few standard SSRS reports and creating a Ref

Author: Dattatrey Sindol

>>> https://www.mssqltips.com/sqlservertip/2561/querying-sql-server-agent-job-information/
Wait while more posts are being loaded