Journey to SQL Authority with Pinal Dave | SQL, SQL Server, MySQL, Big Data and NoSQL MICROSOFT DATABASES SSWUG.ORG facebook twitter youtube Latest Video Recent Videos White Papers Latest White Paper Six Steps to Managing Data Quality with SQL Server Integration Services Read More Recent White Papers How to Use SQL Server’s Extended Events and Notif How to Use SQL Server’s Extended Events and Notif Top 10 Tips for Optimizing SQL Server Performance Top 10 Tips for Optimizing SQL Server Performance Extending the Value of SCOM with Spotlight on SQL Articles Latest Article SQL Server Integration Service (SSIS): Import and Export wizards In this article, I'm going to show you how you can import and export data to and from SQL Server database using SQL Server Integration Services (SSIS)... Read More Recent Articles SSWUG.ORG Data Professional Resources Home | Media | Articles | Scripts | FAQ's | List Server | Whitepapers | Products | Editorials | Tag Help | Original Content SSWUG Pro Membership | Newsletters | Upcoming Events | News | About Us | Jobs | SSWUG Merchandise | 10.210.203.42
Coding Starts Here Argument Is a value provided to a function when the function is called. This value is assigned to the corresponding parameter in the function. Syntax function_name(argument1, argument2, ...): #Function definition Example def sum(a,b): #a & b are two arguments in sum function s=a+b return s Assignment Assignment operator assigns the value to an object, it assigns from right to left. x = 10 # Integer value. x = "John" # String with double quote. x = 'Jack' # String with single quote.# String can be denoted by either a single quote or double quote.x = 45.50 #Float value. The type of a variable depends upon the value assigned. Bytecode Is an intermediate language for the Python Virtual Machine within the interpreter. Class A class is a construct that is used to create instances of itself – referred to as class instances, class objects, instance objects or simply objects. class Class_name: "class documents " #class definition includes data variables, methods, and class Output Code Comments Dictionary break
SQL Server Tutorials and Tips SQL Injection Attacks by Example A customer asked that we check out his intranet site, which was used by the company's employees and customers. This was part of a larger security review, and though we'd not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concepts. We were completely successful in this engagement, and wanted to recount the steps taken as an illustration. "SQL Injection" is subset of the an unverified/unsanitized user input vulnerability ("buffer overflows" are a different subset), and the idea is to convince the application to run SQL code that was not intended. If the application is creating SQL strings naively on the fly and then running them, it's straightforward to create some real surprises. We'll note that this was a somewhat winding road with more than one wrong turn, and others with more experience will certainly have different -- and better -- approaches. We speculate that the underlying SQL code looks something like this: A standalone query of
SQL Server Backup DatabaseBackup is the SQL Server Maintenance Solution’s stored procedure for backing up databases. DatabaseBackup is supported on SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. Download Download MaintenanceSolution.sql. License The SQL Server Maintenance Solution is free. Parameters Databases Select databases. Directory Specify backup root directories, which can be local directories or network shares. DatabaseBackup creates a directory structure with server name, instance name, database name, and backup type under the backup root directory. BackupType Specify the type of backup: full, differential, or transaction log. DatabaseBackup uses the SQL Server BACKUP command: BACKUP DATABASE for the full backup, BACKUP DATABASE WITH DIFFERENTIAL for the differential backup, and BACKUP LOG for the transaction log backup. Verify Verify the backup. The Verify option in DatabaseBackup uses the SQL Server RESTORE VERIFYONLY command. CleanupTime Compress CopyOnly Threads
Discover Everything through Code Little Bites of Cocoa - Tips and techniques for iOS and Mac development - Weekday mornings at 9:42 AM