Latest published stories in SQL Server - DeveloperSites

SQL Server

atom rss
1
likes
spam Like Dislike

Meaning of SEM and Its Importance?
published 190 days, 3 hours, 44 minutes ago posted by pemapema 197 days, 8 hours ago
Wednesday, October 11, 2023 11:11:22 AM GMT Wednesday, October 4, 2023 6:56:02 AM GMT
Meaning of SEM and Its Importance?
*Meaning of SEM *is a crucial online marketing strategy that uses paid advertisements to boost a website's visibility on search engine results pages. It involves targeting specific keywords and optimizing ad campaigns to reach the target audience and drive relevant traffic. SEM includes both paid search advertising (PPC) and organic search engine optimization (SEO), with SEM focusing on paid advertisements alongside organic results. (more)
category: SQL Server | clicked: 0 | comment | | source: upskillrocket.in
1
likes
spam Like Dislike

Meaning of SEO and its Importance
published 190 days, 3 hours, 44 minutes ago posted by pemapema 197 days, 8 hours, 53 minutes ago
Wednesday, October 11, 2023 11:11:22 AM GMT Wednesday, October 4, 2023 6:03:10 AM GMT
Meaning of SEO and its Importance
The Meaning of SEO (Search Engine Optimization) can be understood by the dynamic art and science of improving a website's visibility and ranking on search engine results pages (SERPs), also referred to as search engine optimization or SEO. It is a complex approach that entails fine-tuning several aspects of a website, such as its content, architecture, and backlink profile, to comply with the constantly changing algorithms employed by search engines which includes Bing, Google and Yahoo. (more)
category: SQL Server | clicked: 0 | comment | | source: upskillrocket.in
1
likes
spam Like Dislike

Elevate Your Professional Skills with Learners Ink
published 408 days, 2 hours, 2 minutes ago posted by DavidSmithDavidSmith 409 days, 7 hours, 29 minutes ago
Tuesday, March 7, 2023 12:53:20 PM GMT Monday, March 6, 2023 7:26:49 AM GMT
Elevate Your Professional Skills with Learners Ink
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 424 days, 22 hours, 52 minutes ago posted by DhruvDhruv 433 days, 1 hour, 19 minutes ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 1:36:29 PM GMT
Mastering the Art of SQL: A Guide to the Row Number Function
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 424 days, 22 hours, 52 minutes ago posted by DhruvDhruv 433 days, 2 hours ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 12:56:02 PM GMT
Mastering SQL Server Triggers: A Step-by-Step Guide with Best Practices
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 424 days, 22 hours, 52 minutes ago posted by DhruvDhruv 433 days, 2 hours, 1 minute ago
Saturday, February 18, 2023 4:04:00 PM GMT Friday, February 10, 2023 12:54:30 PM GMT
Unraveling the Mystery of SQL Server Data Types: A Comprehensive Guide
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 841 days, 1 hour, 38 minutes ago posted by matthewpomarmatthewpomar 850 days, 23 hours, 49 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 3:06:48 PM GMT
When and When Not To Use NOLOCK
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 841 days, 1 hour, 38 minutes ago posted by matthewpomarmatthewpomar 850 days, 23 hours, 56 minutes ago
Wednesday, December 29, 2021 1:17:53 PM GMT Sunday, December 19, 2021 2:59:45 PM GMT
Good Reasons Not To Use SQL Server To Send Emails
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