(Vladimir Kislicins) Push notifications with IBM Worklight Foundation is a very powerful feature which makes it possible to reach client devices from a single common server code regardless of the vendor services (APNS or GCM). It also makes the entire process of communicating with the users and devi
Other News
Poor-Man’s Disaster Recovery: Use Log Shipping for SQL Server (at Your Own Risk)
(Thanh “OJ” Ngo) This week, we’ll take a closer look at part 2 of our series on application high availability and disaster recovery (HA/DR) for SQL Server: Log shipping for SQL Server implementations.
Recognizing Relational Anti-Patterns
Maurice shares another relational database anti-pattern. I saw a case where a table had rows with a single meaning from business rules. They extend the application and add a type to the row for new business cases. The table became very complex to query, since there was alternate rows for the original business case. In the beginning getting the most […]
Tips for using data types in SQL Server 2014
Tips for using data types in SQL Server 2014 Use Date/Time data types to store date/time information separately. In SQL Server 2014 you can store the date and time information separately. For example, if you need to work with date data only, use the Date data type instead of datetime or smalldatetime to optimize storage space and simplify date modifications...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Identifying large queries using Extended Events
(Andrew Pruski) Following on from my last blog post I now want to run through how to identify large queries using Extended Events.
Query Object Dependencies
(Derik Hammer) SQL Server Management Studio has a decent interface for viewing object dependencies, check out TechNet for those procedures. But, we all know the value of being able to run queries for the information that we need. There are two methods that we’re going to cover for finding object dep
Adding code comments through a sliding jQuery Sidr panel (DITA)
(Tom Johnson) If you write developer documentation, you know that developers prefer code samples to narrative instruction. The beauty of code samples is that they provide context at a glance. You can see where variables should be declared, functions called, objects initialized, and so forth — all by
CRUD OPERATIONS WITH ASP.NET WEB API USING FLUENTNHIBERNATE, REPOSITORY PATTERN
(Gaurav) In this step-by-step article we will discuss all about CRUD (Create Read Update Delete) operations with Web API using Repository pattern.
DB2 Tips n Tricks Part 46 – How to Find Fenced User ID for an Instance
(Harishkumar Baburao Pathangay) How to Find Fenced User ID for an Instance Solution:
The DB2Night Show z51: Willie’s Winging It Volume 3
(Martin) 100% of our studio audience learned something! Willie provided insight into a number of topics including service levels, documentation, zIIPs and statistics.