Latest published stories in SQL Server - DeveloperSites
1
likes
spam Like Dislike

Elevate Your Professional Skills with Learners Ink

published 23 days, 5 hours, 8 minutes ago posted by DavidSmithDavidSmith 24 days, 10 hours, 34 minutes ago
Tuesday, March 7, 2023 12:53:20 PM GMT Monday, March 6, 2023 7:26:49 AM GMT
At Learners Ink, we pride ourselves on being the premier provider of professional course training. Our team of experienced instructors is dedicated to helping you reach your full potential and achieve your career goals. With a wide range of courses covering a variety of industries, we have something for everyone. Whether you're just starting out in your career or looking to take the next step, Learners Ink has the training you need to succeed. If you're looking to advance your career in project manageme... (more)
category: SQL Server | clicked: 1 | comment | | source: www.learnersink.com
1
likes
spam Like Dislike

Mastering the Art of SQL: A Guide to the Row Number Function

published 40 days, 1 hour, 57 minutes ago posted by DhruvDhruv 48 days, 4 hours, 25 minutes ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 1:36:29 PM GMT
The blog post at simplilearn.com discusses the Row Number Function in SQL. The Row Number Function is a feature of SQL that allows you to assign a unique number to each row of a result set. This can be useful in many different situations, including data analysis, reporting, and data processing. The blog post begins by providing a brief overview of the Row Number Function, including its syntax and basic usage. The post then provides several examples of how the Row Number Function can be used in real-worl... (more)
category: SQL Server | clicked: 0 | comment | | source: www.simplilearn.com
1
likes
spam Like Dislike

Mastering SQL Server Triggers: A Step-by-Step Guide with Best Practices

published 40 days, 1 hour, 57 minutes ago posted by DhruvDhruv 48 days, 5 hours, 5 minutes ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 12:56:02 PM GMT
This blog post on MSSQL Tips is about SQL Server triggers. It starts by explaining what a trigger is in SQL Server and how it works. A trigger is a database object that is automatically executed in response to certain events that occur within the database. The events can be either data changes or user-defined events. Triggers are used to enforce business rules, automate tasks, and maintain data integrity. The blog post then goes on to provide a step-by-step example of how to create a trigger in SQL Serv... (more)
category: SQL Server | clicked: 0 | comment | | source: www.mssqltips.com
1
likes
spam Like Dislike

Unraveling the Mystery of SQL Server Data Types: A Comprehensive Guide

published 40 days, 1 hour, 57 minutes ago posted by DhruvDhruv 48 days, 5 hours, 7 minutes ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 12:54:30 PM GMT
The blog post provides an overview of the various data types in SQL Server, a relational database management system. SQL Server supports a wide range of data types, including character strings, Unicode character strings, binary data, and various types of numbers. The article provides a brief explanation of each data type, including its purpose, syntax, and usage. The first section covers character strings, including the char, varchar, and nchar data types. The char data type is used to store fixed-leng... (more)
category: SQL Server | clicked: 0 | comment | | source: www.sqlservertutorial.net
1
likes
spam Like Dislike

When and When Not To Use NOLOCK

published 456 days, 4 hours, 43 minutes ago posted by matthewpomarmatthewpomar 466 days, 2 hours, 54 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
To NOLOCK or Not to NOLOCK... That is the question. Lots of developers who don't fully understand the requirements of their application or how NOLOCK works will indiscriminately add NOLOCK to all of the SQL queries. But doing so isn't always the best decision. Brent Ozar describes some times when it is beneficial to use NOLOCK and times where it isn't the right choice. (more)
category: SQL Server | clicked: 1 | comment | | source: www.brentozar.com
tags: MS SQL, Performance
1
likes
spam Like Dislike

Good Reasons Not To Use SQL Server To Send Emails

published 456 days, 4 hours, 43 minutes ago posted by matthewpomarmatthewpomar 466 days, 3 hours, 1 minute ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 2:59:45 PM GMT
When all you have is a hammer, everything looks like a nail. Over the years, I have seen my fair share of complex SQL Server applications, where loads of business logic exist in stored procedures and cursors churn through thousands of records handling complex business rules and sending out emails. But there are some really good reasons not to send emails from SQL Server. In his blog, Brent Ozar describes some of these reasons. (more)
category: SQL Server | clicked: 3 | comment | | source: www.brentozar.com
tags: Email, MS SQL